I need to convert the backend database of my application from an mdb to an accdb. I have about 200 installations so I need to do this as a data conversion in VBA.
I am considering:
- Installing an empty accdb containing the tables but no data.
- Then, for each table in the mdb, adding the records to the corresponding table in the accdb.
- Finally, unlink the table in the mdb and relink to the tables in the accdb.
Does this sound reasonable or is there a better way?
Thanks in advance