Monday, August 1, 2011

Microsoft Access 2010 :: Related Databases Moving

Recently I had to move and convert some Access database files to newer versions. I have a database with backend data and a database with frontend queries tasks. So After I individually saved the files as Office 7 compliant I had to go back in and reconnect them. Here were the steps in case this is something you are working on in Access 2010 or Access 2007.
  1. Click External Data
  2. Click Linked Tables Manager
  3. Click Select All, OK, and Close
If this does not immediately find the related file you may have to click the checkbox for "always prompt for new location" and then it will allow you to browse to and select the proper database. This is necessary if you rename or convert the file instead of just moving it.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
Web Design & Marketing - Click and get an instant quote on your project