The database was originally created in MS Access 2000. It has been necessary to migrate this database and macro across to later versions of MS Access (e.g. 2003, 2007). Q: Describe some potential problems or issues when migrating to a newer version of Access.How would you go about resolving these issues?
I never found any issue in conversion. But you need to change the OleDB driver to the newer version to access these databases from VB. (According to my memory, 3.5 for Access 2000 and 4.0 for 2003)