Continued problems opening 2010 DB in 2007

rspahitz
rspahitz used Ask the Experts™
on
I followed a previous question for opening a 2010 in 2007 but no luck.

I updated my computer to the latest Windows 7 updates (including some for Access) but I still get this when I open the DB:

Unrecognized database format 'C:\...accdb'.

How do I identify the Access 2010 features referred to in the help file here?
http://msdn.microsoft.com/en-us/office/cc907897.aspx

And does this mean I need Access 2010 to save a file in 2007 format so I can use it on my 2007 installation?  This is crazy!

Further, when I try to import into a blank 2007 DB, I get the same message when I select the DB.
(Maybe my updates didn't include SP2?  I forget how to check this.)

Can I open the DB in VB.Net the recreate it from there maybe?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Personally I have not managed to open any of the databases created in A2010 in version A2007.
Recently I saw a post that said that you must remove the Layout from any form and report you have created in A2010 for it to be compatible with A2007.  I haven't tried this yet, but you might want to give it a go.

Alternatively, are you able to save your database (in A2010) as an mdb file and try that in A2007?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I have had success by creating a new DB in Access 2007.
Then importing all of objects from the 2010 DB into this new Acc 2007 DB.

(You may get an alert about certain Access 2010 features not being carried over.)
Then open the DB in Access 2007 and test.

Then open the DB in Access 2010 and test.
If something is missing or not functioning then note this as something that just wont work in 2007...

My feeling is that some new features in Acc2010 are simply not compatible with 2007, hence the error.

(This being said, I believe I saw a post that stated that you could delete some system table as well)

JeffCoachmnan

Author

Commented:
Thanks boaq.  I tried to import into a blank 2007 DB and it still wouldn't open the file (so it wouldn't even get to the point of being able to show the objects.

Peter, I tried saving as a 2003 format/mdb and got an error.  Maybe now that I understand it, those errors will give me a clue as to what is blocking it.
I'll also try removing layouts and see how it goes.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Just an observation...
I tried to save the database as an MDB and I don't have that option--it only lets me save as an accdb file.
So I did that and changed the extension to mdb and it opens in 2010.  I'll see if that works at home on 2007.
If someone knows another way to save-as 2003/mdb, let me know.

Author

Commented:
Further, if I go to options and try to change the "Default file format for Blank Database" to "Access 2002-2003", I get the following error:

"
{your DB} cannot save the database to the Access 2002 - 2003 file format.
The specified database sort order, General, is not supported for the target database format.
"

Really???
All the other database sort orders available to me are foreign languages, and the default is "General - Legacy", which certainly looks like it should be backward compatible!!!???

Author

Commented:
As a test, I removed the handy-looking "Navigation" forms to see if that's causing he problems with the 2007 format.  I'll find out when I get home tonight, but other thoughts would be appreciated.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<So I did that and changed the extension to mdb and it opens in 2010.>
...and everything works?
I try to avoid things like that like, as I would like to know what the real issue is.

Besides this "renamed" file will probably not work in access 2003 because it is really a accdb file, so again, I would avoid doing this...

Can you post a generic sample of this "incorrigible" db?
;-)

Jeff

Author

Commented:
changing the extension to mdb still let it open in Access 2010, but I haven't tried in 2007 yet.  I suspect it will still fail.

Since the DB is just in the design stages, I guess I can post it.
 InventoryTracker.zip

But I have enough work into it that I'd rather not re-create it if I can avoid it.
--
Rob

Author

Commented:
I ignored the errors I got when I selected using 2002-2003 format and it now let me create an mdb file.

From that I was able to import all the pieces from the 2010 DB into it (minus some minor things it didn't like.)
So when I get home, I'll try to load that into 2007 and see if it works (which it should if it's truly an mdb file.
If so, I'll close the Q.

However, if someone knows how to save the attached DB in 2007 format directly, rather than as mdb then opened in 2007, I'll give at least some points to that too.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
OK,
I test this out at work tomorrow where I have 2007 and 2010

Author

Commented:
FYI
Converting to mdb (by changing the 2010 options) created a file that works fine on 2007.
boaq, Let me know if you have any insights or findings that help explain things before I close the question.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
When you say "changing the 2010 options", do you mean the "Form Navigation" features

As stated, I can open it fine in 2010 but not in 2007
Commented:
File / Options / General / "Default file format for Blank Database"
I switched that to "Access 2002 - 2003", ignored the sill error, and when I restarted Access, I was able to save-as mdb.

When I migrated everything to a blank 2002/3 DB and looked at the resulting file, the form navigation stuff was gone, but I can deal with that.  It looks like everything else, including relationships, were intact.

But if there's a way to save a 2010 DB (which is supposed in 2007 format) in such a way that 2007 can open it (even if it throws away a few 2010-specific features) that would be good to know since I'm not sure what else I may have lost by going back to 2002/3.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Ok, thanks for the update.

Yeah, ...I have been researching this for a while now.
I'll try to look up that link that mentioned something about deleting a system table...

Author

Commented:
Not the ideal solution to save 2010 DB as 2003 then open in 2007, but at least it worked with minimal loss since it was a new DB that wasn't built too far yet.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial