WSID problem in linked table

[xjhacking]

Hi guys!

I've made a database with a linked table, which makes a connection to a SQL-server. The database is located on the office network and has to be used by multiple users. Problem is that the linked table only works on the computer of the user that set up the linked table in Access. Reason is probably that the unique computer ID is coded into this connection, via WSID (Workstation ID).

In the table properties I tried to remove this but Access doesn't seem to react. After deleting the WSID phrase, closing the properties window and re-opening it the WSID is back again.

Is there a way to remove this WSID or to make the linked table accessable for all users?

Thanks!

 

[Rabbie]

You should be able to relink the tables the way you want by using the linked Table manager.

Tools --> Database Utilities --> Linked Table Manager

 

[xjhacking]

Thanks Rabbie, but this would mean that everytime another users wants to use the linked table this action has to be performed?

 

[Rabbie]

Thanks Rabbie, but this would mean that everytime another users wants to use the linked table this action has to be performed?

The correct links to the BE tables should be preserved once they are set correctly. If necessary you would need to do this on the individual FE databases if they have different routes to the BE.

See this link for more info http://www.allenbrowne.com/ser-01.html