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 [url removed, login to view] 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 [url removed, login to view], if is not equal than the exe the update begin. 3º The routine copy the [url removed, login to view] to [url removed, login to view] 3º The routine apend all the data from [url removed, login to view] to [url removed, login to view] 3º Rename the [url removed, login to view] with [url removed, login to view] 4º Rename the [url removed, login to view] to [url removed, login to view] 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 [url removed, login to view] 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?
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.