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 convert.
- 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 box.
- 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 box.
- 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 Split.
Step 3 Connect the new front-end to the original database
- 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 browser.
- If all goes well, Access displays a message stating that all selected linked tables were successfully refreshed.
Ask Your Question
Got a programming related question? You may want to post your question here