Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Hi
I have a database developed using Access 2003 where I set the default file format to Access 2000 (under Tools > Options > Advanced). The database runs nicely in Access 2003 but if I try to open it using Access 2000 then the very first time I start up the database, none of the VBA code works whatsoever. It simply refuses to run.
If I shut the database and re-open it in 2000 (without changing anything) then the VBA runs perfectly. I have fiddled with all of the startup options available under 2003 but to no avail. Has anyone else come across this problem before? And if so, how do you resolve it?
Thanks in advance
Andrew
I have a database developed using Access 2003 where I set the default file format to Access 2000 (under Tools > Options > Advanced). The database runs nicely in Access 2003 but if I try to open it using Access 2000 then the very first time I start up the database, none of the VBA code works whatsoever. It simply refuses to run.
If I shut the database and re-open it in 2000 (without changing anything) then the VBA runs perfectly. I have fiddled with all of the startup options available under 2003 but to no avail. Has anyone else come across this problem before? And if so, how do you resolve it?
Thanks in advance
Andrew