Hi
Is there any way to save an Access 2013 database (.accdb) down to a lower version of Access (.mdb file)?
Paul
- Moved by Lanlan HuangMicrosoft contingent staff 5 hours 38 minutes ago
Technology Tips and News
Hi
Is there any way to save an Access 2013 database (.accdb) down to a lower version of Access (.mdb file)?
Paul
Yes: select File > Save As.
Then select either Access 2002-2003 Database (*.mdb) or Access 2000 Database (*.mdb).
Click the Save As button.
Specify a folder and a file name, then click Save.
HV, have never attempted this - some new features not understood in the earlier version, like split forms and such, I assume will cause it to barf....
but will there be issues with VBA code if written in 13 and then attempting to go back to say 03 or earlier? i.e. the pre ribbon era......
I've always been super cautious in developing in the edition the user has.....but maybe I am going overboard.... I know the features so I can avoid using feature like say data macros that I know did not exist in say 03 - - but have concern on generic vba code as well and the library references......
You have to be very careful, of course.
Standard references such as those to the core VBA library and to the Access library should be converted automatically when someone opens the database in an older version. Non-standard references such as the Excel library will cause an error though, so it's best to use late binding wherever possible if you want the database to be opened on older versions.