Access 2003 linked tables causes read-only

[Jim McDonald]

Hi
A weird one - I have an Access 2k mdb set with linked tables. Ive opened the
set under Access 2003. If the link is to the c: drive (where the functions
are) all is OK, but if I put the mdb with the tables in on a net drive (eg
X:\.....) the tables become read only and I can find how to stop this.. Any
help anyone, please???!!??
thanks
Jim McDonald

 

[Douglas J. Steele]

What permissions do you have on the folder where the mdb has been placed?
You must have Change permissions (Read, Write, eXecute and Delete) on the
folder, not just the file.

 

[Jim McDonald]

Hi
Permissions are set to "everything for all" in the folder and its
subfolders.
The reason for the setup is because the user has X:\ mapped on a server, and
my test environment simulates this by mapping the folder on the local (C:\)
drive to X:\ so the Link Table Manager sees the same link (X:\........)
If I link to C:...fine; if I link to X:.. I get the RO problem.
Any further ideas, please?
Thanks
Jim

 

[Jim McDonald]

Hi again Doug - please ingnore earlier response (Idiot boy too quick!!) - I
missed a top folder which was included in the link. Now AOK
Thanks for your help
Jim