Show Bid Request MDB Update with ADO Bid Request Id: 37313 Bookmark in my 'To Do' list Posted by: LGI (0 ratings) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Good Approved on: Nov 27, 2002 2:45:40 PM EDT Bidding Closes: Jan 3, 2003 EDT Viewed (by coders): 201 times Deadline: 1/8/2003 TIME EXPIRED Phase: Cancelled Max Accepted Bid: Bidding is closed Project Type: Small Business Project: $100 (USD) + Bidding Type: Open Auction Categories: Database, Language Specific, Visual Basic, Access Enter chat room for this bid request (0 active users at Sep 30, 2003 6:45:16 AM EDT) Description: I need a routine to update a MDB with the new MDB structure in ADO. I have a MDB in the client. When they update the program.exe the program detect the new version off the aplication and make the changes in the current mdb from one blank mdb structure or from one array or code of the new estructure. I need the actual mdb update and all the current data equal. Evidently If I don't delete fields, etc. If one field change of type or lenght the new estructure preserve the information like it's posible. My application is in VB6 & MDB Access 2000. I work with Microsoft Activex Data Object 2.5 Library One Coder try it to make it like this with ADOX but the problem are the relationship's. I thing is better this system : 1º Whe send a empty mdb with the new strucuture (all tables, indexes, relations and one special table called version with only one field with the number of exe version) 2º The routine verify the version off the table version in customer.mdb, if is not equal than the exe the update begin. 3º The routine copy the empty.mdb to update.mdb 3º The routine apend all the data from current.mdb to update.mdb 3º Rename the current.mdb with currentDATETIME.mdb 4º Rename the update.mdb to current.mdb Ok it's simple but I make this consideration's : 1º I think the routine can automatic append the table's from customer that they are in empty.mdb 2º The routine need to control the relationship to make the append's or inserts ? 3º What need the routine to insert records preservating the autonumeric fields ? 4º Is need anything control to ensure the correct update? foreign keys, etc 5º What happend with the international fields like money? I think this is all I need, any suggestions? Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. Platform: Windows 98,2000,ME,XP Must be 100% finished and received by buyer on: Jan 8, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Special Conditions / Other: I need this routine the next week. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   No bidding allowed, because this bid request was cancelled. Cancelled Date: 12/3/2002 7:09:31 PM