• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1144
  • Last Modified:

Access 2007 wont open database made in Access 2010

Hi,

I have made a database in Access 2010.
I understand that 2010 and 2007 use the same format .accdb? yet when i try to open the db in access 2007 i just get a message saying "unrecognized file format"

any ideas on what may be causing this?

Thanks for reading
0
laserhalen
Asked:
laserhalen
  • 3
  • 3
2 Solutions
 
Carl TawnSystems and Integration DeveloperCommented:
There are certain features in 2010 that will prevent it opening in 2007.

Details of specific feature incompatibiltiy can be found here:

    http://msdn.microsoft.com/en-us/office/cc907897.aspx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Try creating a blank A2007 accdb, then importing all objects from the A2010 accdb (except linked tables) into the A2007 accdb.

mx
0
 
laserhalenAuthor Commented:
Thanks for that.
..in table 1 on the page you sent me i think its "Access 2010 Encryption Compliance" because its the one that stops the database from opening. (i have checked the database sort order and its set to General - Legacy)

how do i check / change the encryption?

Also see the attached warning i get when about to open the database (just after converting to 2007)
Do you know what links are being referred to and how do i change them to 2007?

AccessInfo.JPG
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
laserhalenAuthor Commented:
@DatabaseMX: sorry you must have commented while i was writing mine..
when you say linked tables - do you mean tables with relationships or tables that are populated from other tables? ..because in the latter i have used regular SQL..why does 2007 have a problem with it?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"when you say linked tables"
I mean if you have a Front End 'linked' to tables in a Back End (aka 'split' configuration), don't import the links.  Relink after you import all other objects.

I you only have a Single accdb, then ignore that part.  And yes, do ... import any relationships in this case.

mx
0
 
laserhalenAuthor Commented:
im failing here..i have opened a blank database and imported all the objects, leaving out some linked tables..i dont get the warning about the compatible links..
when i try to open in 2007 i get the same message "Unrecognized database format.."
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Sorry, I thought that might work.  It sounds like it's pretty much what carl_tawn posted ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now