Best Method to Convert Access files to version 2010

[IMNovice]

I have many files in the mdb file format....mainly from Access 97, 2000 and 2003. What is
the best method to convert them to version 2010? Many files have macros and modules in VBA.

Please, only responses from experienced members only, such as Access/Excel MVP's.
Thanks.

 

[boblarson]

The BEST method that I've found, because it is the most reliable in making sure all converts, is to IMPORT everything into a blank database shell. I would not use the SAVE DATABASE AS feature. It seems to create more problems than it helps with.

 

[IMNovice]

Thanks Bob,

But can you guide me through the process? Is there a VBA procedure that can
automate the process?

Thanks!

 

[boblarson]

Thanks Bob,

But can you guide me through the process? Is there a VBA procedure that can
automate the process?

Thanks!

I would NOT trust the upgrading process to an automated procedure. Also, if you don't need to upgrade the files, DON'T. They can be used as is, and don't need to be changed to the latest format UNLESS you NEED some of the newer features.

 

[HiTechCoach]

I would NOT trust the upgrading process to an automated procedure. Also, if you don't need to upgrade the files, DON'T. They can be used as is, and don't need to be changed to the latest format UNLESS you NEED some of the newer features.

I agree with Bob's recommendations.

I would not convert the format to a .accdb unless you absolutely have to.

I also find it best to create a blank new database and import all the objects from the mdb to the new .accdb.