VBA won't run on first opening of DB

[Andrew Fergus]

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

 

[Andrew Fergus]

Ok. I think I have this sorted thanks to Denis. I created a new database using the 2000 version of Access, made sure all of the references I needed were enabled, imported all of the objects from the 2003 version of the database and the problem has disappeared. I would have thought the differing versions of the MSACC.OLB (version 9 vs 11) wouldn't have been a problem given I created the database using the 2000 format - but obviously not.

Cheers
Andrew