switchboard calls wrong path

[madwoman]

Hi

I have just inherted a Personnel System which appears to have two linked databases:
PersonnelDatabase.mdb
PersonnelStorage.mdb

It was originally operated from a server but is has now been copied onto a single user PC. Whilst it was on the server if you opened PersonneDatabase.mdb you would see the tables for a couple of seconds and then the switchboard screen would kick in. Now that it is on a single user machine instead of the swictchbaord kicking in I get an error message saying that the path to PersonnelStorage.mdb is not valid and it shows the path as if it were still on the server. How do I reset this so that the system will work on a the local machine?

Any advice would be appreciated

 

[poet1234]

There is some code in the parent database that needs to be changed to reflect the correct path. You might check behind the buttons on the switchboard form, or whatever form is the first form launched when the parent database starts up. You can find the startup form by going to the to Tools --> Startup --> Display form/page. Hope this helps.

 

[wardster]

Sounds to me as though you will need to relink the tables.

Tools > Database Utilities > Linked Table Manager

select the tables that point to the wrong path, tick "prompt for new location" then ok - browse to correct location of data

hopefully then all should work again

Ian

 

[madwoman]

Hi

Thanks the Linked Tables are what are causing the problem. I have reset those and now it's fine.

Cheers