Read only (for some users)

[ggodwin]

I am getting a Read Only error for one user? Is there a setting anywhere that would create this?

 

[Rabbie]

Which Version of Access and which Version of Windows is this person using?

 

[ggodwin]

Creator : Acess 2003 SP3, Created with Window XP2
User with Error: Acess 2003 SP3 Windows XP2

All the same

 

[Rabbie]

Does the user with error have full access to the folder. Have you implemented Security on the DB.

 

[ggodwin]

I have not implemented anything.
I have checked just three computers.
#1) No problem all functions are fine...
#2) Read Only
#3) Is getting an error stating a table is missing when it is not. (#1 PC can run it fine also)

This is on a shared drive.

 

[Rabbie]

I have not implemented anything.
I have checked just three computers.
#1) No problem all functions are fine...
#2) Read Only
#3) Is getting an error stating a table is missing when it is not. (#1 PC can run it fine also)

This is on a shared drive.

#2 needs to be given full access to the folder where your DB is.

Check what access #3 has to that folder. It sounds as if there is an issue there.

 

[RossWindows]

You said the db is on a shared drive?
Do you mean it is stored on another PC, or is it on a network server?

You probably need to change the linked-table paths to UNC paths \\server\path\
or \\computer\sharedfolder\
instead of mapped drives like Y:\

Or you have to make sure that all machines have the same mapped drive.
#3 must be missing the mapped drive, or it got assigned the wrong letter

 

[boblarson]

And for multiuser use you really should

1. Split the database into a frontend/backend (backend with tables only)

2. Put the backend on the server

3. Put a copy of the frontend on EACH user's machine.

See here for more about that:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm