ODBC Table Links not Persisting in Access Reports
- Product: Voyager
- Product Version: 8.2.0
Problem Symptoms
- Table links don't persist after closing Reports.mdb file
- Need to relink all the tables after every PC reboot
Cause
Incorrect registry entry
Resolution
- Open the Registry by typing regedit in the Start menu
- Navigate to HKEY_CURRENT_USER > Software > ODBC> ODBC.INI > VGER
- Right click on the SERVER string value and click Modify...
- Change the Value Data from your hostname or IP address to VGER
- Close the Registry
- Open Access & relink the tables
- Article last edited: 08-Oct-2013