Avatar of rspahitz
rspahitz
Flag for United States of America asked on

Continued problems opening 2010 DB in 2007

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?
Microsoft AccessMicrosoft ApplicationsMicrosoft Office

Avatar of undefined
Last Comment
rspahitz

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
peter57r

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

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
rspahitz

ASKER
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.
rspahitz

ASKER
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
rspahitz

ASKER
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!!!???
rspahitz

ASKER
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 Coachman

<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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
rspahitz

ASKER
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
rspahitz

ASKER
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 Coachman

OK,
I test this out at work tomorrow where I have 2007 and 2010
Your help has saved me hundreds of hours of internet surfing.
fblack61
rspahitz

ASKER
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 Coachman

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
SOLUTION
rspahitz

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

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...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
rspahitz

ASKER
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.