Error starting an Access 2003 application in Access 2007
My organization is in the process of upgrading from Access 2003 to Access 2007. One of the applications I have been assigned to upgrade is returning very strange errors when opening and closing forms with nested forms. Have events changed between Access 2003 and Access 2007? It seems that in 2007 these events were dismissed in a different order than in 2003.
source to share
I have not come across the situation you described. I can't find anything that mentions changes in the event model form. Allen Brown has some information on the compatibility of Access 2007 with older versions: http://allenbrowne.com/Access2007.html#Compatibility
The only issues I have experienced so far with the 2003 MDB in Access 2007 have been link breaking. If you haven't already, double check yours (Tools-> Links) from the VB editor. There, try Debug -> Compile to see if your code will compile without errors in Access 2007.
Tony Toews "Corrupt Microsoft Access FAQ MDBs can help fix or eliminate weird corruption-related behavior:
http://www.granite.ab.ca/access/corruptmdbs.htm
If you have done these things and are still having problems with certain forms, it might be helpful to create a new empty database and import those forms (and the objects they depend on) into the new database.
Sorry to shoot this thing. It might help if you can provide more details on the nature of the errors you are getting.
source to share