469,647 Members | 1,677 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

Compatibility access 2010 to 2007

158 100+

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
5 12077
14,534 Expert Mod 8TB
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
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
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.

Jun 11 '10 #4
14,534 Expert Mod 8TB
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
14,534 Expert Mod 8TB
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.

Similar topics

1 post views Thread by Johnny E Jensen | last post: by
10 posts views Thread by prakashwadhwani | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.