Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1142
  • 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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