Linking Tables

[deiopajw]

I have a front end and a back end database.
The database is on a network server.
However, every time a user with a laptop for instance comes back into the
office and connects his laptop to the network server to use the database, a
message comes up stating that there is no path linked from this front end
database to the back end.
I simply have to ritually delete the existing table links in the database
window and reinstate them again. Why does this happen every time a user
disconnects and connects to the network server??
This missing path link message also appears soon after having done some
editing to the database.

 

[Arvin Meyer [MVP]]

It is quite possible that the network mappings are not being re-established
as quickly as the connection is being opened. That usually happens if
there's lots of spyware or other junk, including some antivirus programs,
starting when the machine is turned on. Try cleaning the machine, then
waiting a bit longer before opening the database. If that doesn't work, try
using this relinking code to automatically relink the database:

http://www.mvps.org/access/tables/tbl0009.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access