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
Microsoft AccessMicrosoft OfficeMicrosoft Applications
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
..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