access to split database

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I created a database that is set to shared to be accessed
by three computers. I have split the database and I'm
able to access it from the computer that it was orignally
loaded on but the other two give me an error message
that "invalid path" when I try to access the frontend yet
I'm able to access the backend with no problems. What am
I doing wrong?
 
The links in the frontend are pointing to the location as seen from
the original machine, and is probably based on a mapped drive, or its
local C: drive. Instead, you must use a UNC name for the link.

Two choices, both of which involve Tools > Add-Ins > Linked Table
Manager

1) manually update each of the other two machines
2) mount the backend in a central location that can be seen from all
three machines. Modify the original frontend to point to the correct
location, and then distribute to the other two machines.

Tony Toews site has a tool for automating the relink process for when
you distribute a new frontend to the other machines.
www.granite.ab.ca/accsmstr.htm

I created a database that is set to shared to be accessed
by three computers. I have split the database and I'm
able to access it from the computer that it was orignally
loaded on but the other two give me an error message
that "invalid path" when I try to access the frontend yet
I'm able to access the backend with no problems. What am
I doing wrong?
Click to expand...


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
 
The front end must be set up individually on each machine
as the front end is not been shared
 
Back
Top