Question Linked table issues from computer to computer

[macwiz]

I am using Access 2007 to create a front end to a SQL database. To share the Access db I create an ACCDE file for others to use on their computers.

When other people use the ACCDE version they have to use the linked table manager to refresh the tables in order to initialize the connection. When I use either the original db or the ACCDE version I don't need to do this step. Any ideas on how to resolve for other computers?

 

[Vassago]

The entire linked path has to match on all machines. You'll want to use a full network path instead of mapped drives if you are doing so, that way it'll work on all machines.

 

[macwiz]

Perhaps I'm just missing something completely, but for a SQL server ODBC linked table there's no file path to ensure is complete. If it makes a difference the db is located on my local machine and the ACCDE file is saved in a network shared drive.

 

[gemma-the-husky]

you need some sort of standard code to check that the backend is correctly connected - and you should use this in your own copy as well.

I would think most developers store an "expected path" somewhere - eg in a local table, in the registry, in a text file

Then using a known "standard" linked table

check that trhe connection path to this table agrees with the expected path.

if not then reconnect all the table to the correct path. You can even get samrter than this, and have a table with your linked tables, specififying where there individual backends are located - so some tables can be connected to 1 backend, and others ot another.

There are lots of examples of this sort of thing here and elsehgere.