SteveL13
asked on
Unrecognized Database Format
I have a user who created an Access database in Access 2010. But now he needs to be able to run the program in Access 2007 but is getting an error on the 2007 computer... "unrecognized database format".
How can this be fixed?
How can this be fixed?
Check out this article from MS regarding compatibility between Access 2010 and 2007, and saving 2010 files in 2007 format
http://office.microsoft.com/en-us/access-help/save-an-access-2010-database-in-an-earlier-file-format-HA010341553.aspx#_Toc258329151
Also note that there are some Access 2010-specific features that will prevent databases in that format from being opened in 2007 at all (there is a link to specific issues like that in the article)
http://office.microsoft.com/en-us/access-help/save-an-access-2010-database-in-an-earlier-file-format-HA010341553.aspx#_Toc258329151
Also note that there are some Access 2010-specific features that will prevent databases in that format from being opened in 2007 at all (there is a link to specific issues like that in the article)
This is because the saved version of the 2010 access database is not supported in 2007.
If you created a database by using Microsoft Access 2010 and you want to share the database with people who are using versions of Access earlier than Access 2007, you can save the database to an earlier file format by using the Save As command. However, Access 2010 includes a number of new features that can prevent you from saving to an earlier file format.
A complete list of features not supported in 2007 (from 2010 DBs) can be found here:
http://msdn.microsoft.com/en-us/office/cc907897.aspx
I would propose to use Office 2010 to save as an earlier version so that you have no problems.
(1) Open the DB in the 2010 software and save as an earlier version of the database type
- On the File tab, click Save & Publish.
- Under Save Database As, do one of the following:
- To save a copy of the database in a format that can be opened by using Access 2002 or later, click Access 2002 - 2003 Database (*.mdb).
- To save a copy of the database in a format that can be opened by using Access 2000 or later, click Access 2000 Database (*.mdb).
- Click Save As.
If you can not do the above, you can probably search the web for a converter and use a converter to convert to the desirable odler format
If you created a database by using Microsoft Access 2010 and you want to share the database with people who are using versions of Access earlier than Access 2007, you can save the database to an earlier file format by using the Save As command. However, Access 2010 includes a number of new features that can prevent you from saving to an earlier file format.
A complete list of features not supported in 2007 (from 2010 DBs) can be found here:
http://msdn.microsoft.com/en-us/office/cc907897.aspx
I would propose to use Office 2010 to save as an earlier version so that you have no problems.
(1) Open the DB in the 2010 software and save as an earlier version of the database type
- On the File tab, click Save & Publish.
- Under Save Database As, do one of the following:
- To save a copy of the database in a format that can be opened by using Access 2002 or later, click Access 2002 - 2003 Database (*.mdb).
- To save a copy of the database in a format that can be opened by using Access 2000 or later, click Access 2000 Database (*.mdb).
- Click Save As.
If you can not do the above, you can probably search the web for a converter and use a converter to convert to the desirable odler format
<No Points, just summing up...>
Most Access developers will recommend always creating your files in the "Lowest Common Denominator" version of Access.
In other words, if you have 9 users who all have Access 2010 and 1 has 2007, then create (and develop) your database in Access 2007.
Put another way, unless you can ensure that *every user* (Remote workers, Consultants, Vendors, ...ect) that will ever be exposed to this database will have the most recent version, ...then stick with the lower version
JeffCoachman
Most Access developers will recommend always creating your files in the "Lowest Common Denominator" version of Access.
In other words, if you have 9 users who all have Access 2010 and 1 has 2007, then create (and develop) your database in Access 2007.
Put another way, unless you can ensure that *every user* (Remote workers, Consultants, Vendors, ...ect) that will ever be exposed to this database will have the most recent version, ...then stick with the lower version
JeffCoachman
ASKER
Here's where I am with this project.
I have the 2010 created version which is a split database.
I have created two empty databases in Access 2007, one to be a F/E and one to be a B/E file.
Then, using the 2007 F/E I was able to import all objects from the 2010 file into the 2007 file.
But using the 2007 B/E file I cannot import the objects from the 2010 B/E file and cannot figure out why. Something must be in the tables that aren't allowing me to do the import.
????????
I have the 2010 created version which is a split database.
I have created two empty databases in Access 2007, one to be a F/E and one to be a B/E file.
Then, using the 2007 F/E I was able to import all objects from the 2010 file into the 2007 file.
But using the 2007 B/E file I cannot import the objects from the 2010 B/E file and cannot figure out why. Something must be in the tables that aren't allowing me to do the import.
????????
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.
see this link for more info
Backward compatibility between Access 2010 and Access 2007
http://msdn.microsoft.com/en-us/office/cc907897.aspx