Keran O'Brien
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@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?
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?
"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
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
ASKER
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.."
when i try to open in 2007 i get the same message "Unrecognized database format.."
Sorry, I thought that might work. It sounds like it's pretty much what carl_tawn posted ...
mx
mx
ASKER
..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