I want to run an access 2000 database in Office 2007. When we run it in Access 2007, it changes all the VBA references to Access 2007 and Office 2007 dlls and my Access 2000 code won't run properly. I use some calls to Outlook 2000 in the programing and Outlook vba code changed from 2000 to 2003 and 2007.
I have copied over all the dlls and replicated the paths on the Office 2003 and Office 2007 machines so that the references will work correctly.
I can run it in Access 2003 just fine and the references to the dlls work OK, but not in Access 2007.
When I look at the references in VBA on the 2007 machine they are all upgraded to Office 12 references.
Access 2007 has the capability to set new databases to an Access 2000 format but not a way to open them in a specific fashion. I just want 2007 to not change the references to 2007 dlls.