Access 97 - Changing Connection to Linked Tables
Currently going through a migration process for an Access 97 database.
I have managed to get everything working against my development database. I now want to port the database to a test environment for end user testing. However, my knowledge of Access is not very extensive, is there a way that I can change the link in the Access front end to point at the test environment. When I do this with the 'Linked Table Manager', using a different DSN file then I get Microsoft Jet db engine errors that the object cannot be found. This is due to the migration workbench converting the original tables names to proper Oracle formats and adding a '_R' suffix.
Hope someone is able to help.
Jon