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.
  • 1744

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

Categories

More Articles

© 2013 dotNetheaven. All rights reserved.