How do you change the link in a split database
Thanks very much. All is working fine.
"John W. Vinson" wrote:
On Wed, 5 Aug 2009 07:58:03 -0700, texasyankee
wrote:
edI created a database on my local drive. I then copied it to a network drive
and split the database. On the network drive, I have a folder called TeamDB
and within that folder is my mdb file, a folder called Data with the split
data file, and a backup foler.
When I open Linked Table Manager, the link path for all the tables is to my
local drive. How do I change the table links to the network data file?
I have a few users who can't access the DB because of this.
Select all the tables in Linked Table Manager, and check the option "Always
ask for a new location" if you still have a copy of the backend on your PC.
Navigate to the backend Data folder by going all the way up to Network
Neighborhood and back down to Data, and select the backend.
One comment - you should emphatically *NOT* be letting all the users share the
same frontend (from Data). Instead, each user should have *their own copy* of
the database, all linked to the shared backend.
--
John W. Vinson [MVP]
|