Linking Tables in Access 2000

[Bobbyd]

I have an Access database that has several tables that link to an SQLBase database. The application was developed in Access 97 and a conversion to 2000 was done. Everything works fine on my set up however when I try it on someone elses system I get the following problem.

When the db is started it is set to open a form opening the form causes the linked tables to link to the SQLBase database but when I open it on the other persons set up I get an error message which says:

ODBC-connection to C:\Program Files\Common Files\ODBC\Data Source\USER_REPOTING.dsn failed

The DSN does exist and I have recreated it in the correct location.

I have relinked the tables using the Linked Table Manager

If I open one of the tables manually it links without any problem and if I link each of the tables individually and then try to open the form everything works without a problem.

It looks as though there is a setting that restricts auto linking of tables however I have gone through every Option setting and compared it to the settings on my set up and everything is exactly the same.

The only difference is that their version is stored on a network drive however it is opened on the client PC, which is running Win2k as am I.

Does anyone have any ideas as to what could be the cause?

Many thanks in advance for any suggestions you may have.

Thanks
Rob

 

[FoFa]

Did you double check your DSN name?
you put in USER_REPOTING.dsn , but one would assume it should be USER_REPORTING.dsn. Also did you create the DSN as a file or USER or SYSTEM dsn?