Earlier-version database in several versions Access 2010
In this article I am going to explain Earlier-version database in several versions of Access 2010.
Earlier-version database in several versions of Access 2010
- If we use Access version 2000,2002,2003,2007 and we
create our database or project in these version, then if we want to
convert our earlier version Access database in current Access database,
- then we use the following procedure to convert the
database to any of the three most recent formats.
- For example, Access 2000 files can be used in Access
2002, Access 2003, Access 2007, and Access 2010.
- We can create a new front-end database in a later
version and link it to the original file.
- Earlier version of Access are still able to use the
original database and later version can use the new front-end database
to link to the same data.
Step 1 Make a copy of the existing database, and save it in a new format
- First we convert Access database file then we ensure
that no one else has it open.
- Start Access 2010, then we open the file tab and
click open tab.
- Browser open and select the file that we want to
- If the Database Enhancement dialog box appears,
asking whether we want to enhance the database, click No.
- If a form will open when we start a database then we
close the form.
- Then we click save database in file tab.
- Type a name for the new database, in save as dialog
- We save a different database for a different location
from different name.
- Click Save.
Step 2 Split the copy database, and use the
original file as the back-end database
- First we click Database tools, and click the Access
Database in move data group.
- Click split database in the database splitter dialog
- If we want to make a backup, then we could also
re-create the copy by using the original database.
- Create a back-end database name, and then click
Step 3 Connect the new front-end to the original
- First we delete the back-end database that the
database splitter tool created.
- After this process we link a new front-end database
in the original database.
- We click the external database tab and click Linked
table manager in the import & link group.
- Select all and select the always prompt for new
location check box.
- Then click ok button, the earlier version database
- If all goes well, Access displays a message stating
that all selected linked tables were successfully refreshed.
Got a programming related question? You
may want to post your question here