By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

Compatibility access 2010 to 2007

100+
P: 158
Hello,

I have a database that was written in access 2007 on my pc. I wanted to work off site with the database so I uploaded it onto my laptop which is loaded with access 2010 beta.

When I finished working with the database and return it to my pc(which has access 2007) I can't get it open because Access say that the file is not the right format.

Does anyone have a way to work around this compatibility problem?

So you know I didn't changed anything to the database, I simply entered data.
Jun 10 '10 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
When you close and save the database in Access 2010 use the save as option to save it in 2007 compatible version. I haven't used 2010 yet but this would be consistent with any upgrades in the past. Just opening it in new version can have impact on compatibility. Forcing the earlier version compatible save shoud solve your problem.
Jun 11 '10 #2

P: 2
I have the same problem. Then I found this table that talks about the differences between Access 2010 and Access 2007. You need to disable the things in Access 2010 that cannot be viewed in Access 2007 to open your archive in Access 2007 again.
Jun 11 '10 #3

P: 2
Backward Compatibility between Access 2010 and Access 2007
Features that are not available in Access 2007

Microsoft Access 2010 introduces features that are not supported in Microsoft Office Access 2007. Access 2007 Service Pack 1 (SP1) will not open databases containing these features; Access 2007 Service Pack 2 (SP2) will in some cases offer limited viewing and designing capabilities. Therefore, installing SP2 will help you access more applications created in Access 2010.

http://msdn.microsoft.com/en-us/office/cc907897.aspx
Jun 11 '10 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Oh dear :D

I've only just gotten used to the peculiarities of 2007. I don't think I can survive going through this all again.
Jun 11 '10 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
In jaad's case (as I understand it) the database was created in 2007 so the "save as" option should work as long as no design features are added while the database is open in 2010. At least that's the theory :)
Jun 11 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.