I recently updated to Office 2010. After editing an Access database (originally created in 2007), I saved it as an .accde for the users. However, my users all have 2007. They are unable to open the database. I suspect the problem might be in the VBA Reference Library. My references changed from Microsoft Office 12.0 to 14.0. So when I saved the database as an .accdb and had a user open in 2007, the VBA references showed MISSING: Microsoft Office 14.0. I don't know how/if they can add it. If they can't, does anyone know another way to fix this problem?
Access 2010 backward compatibility
- Thread starter jsic1210
- Start date
spikepl
Eledittingent Beliped
- Local time
- Today, 16:43
- Joined
- Nov 3, 2010
- Messages
- 6,134
I have a 2010 accdb I can save and it still opens in 2007 just fine. While changing you have probably used some A2010 specific stuff.
You need to go back to your backup and then redo the steps step by step, each time checking if still can be opened in a2007.
You need to go back to your backup and then redo the steps step by step, each time checking if still can be opened in a2007.
Solo712
Registered User.
- Local time
- Today, 10:43
- Joined
- Oct 19, 2012
- Messages
- 836
The first thing I would check is the version of Office on the A2010 machine. If it is 64-bit version, it won't work. Both machines need to be 32-bit, if you want to run the same compiled code on them.
One way to restore the 2007 functionality would be open a blank database in A2007 and import all the objects from the A2010 database. That would quickly establish any issues between the two versions. As for the two libraries (office12 and 14) co-existing, it is possible but fraught with problems. I would avoid it. I recommend using single code but separate compiles for A2007/A2010/A2013. Also, you will find that code compiled in A2007 is much more reliable when run on the later versions than vice versa. That again assumes that all machines have 32-bit Office installed.
Best,
Jiri
