Access 2002 Unwanted Read Only Attribute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Suddenly my Access databases are Read Only unless viewed by the
Administrator. While trying to fix a networking problem I tried "sharing" my
C directory with other users on the network. According to an Access FAQ this
results in setting databases or directories to Read Only???? I've tried
turning off the Sharing attribute, reassigning control in the
Options>Security dialogue with no luck.
The "Users" talked about in the Options>Security dialogue are they all the
other Users besides the Administrator?
How do I turn the Read Only off? Is this going to be on automatically now?
And another question I don't expect to be answered, why in heavens name
would sharing a folder make everything Read Only??
Thanks
 
One remedy I have found is to go into the non-Administrator User, create an
empty Access database and import everything from the database which was Read
Only. This creates a database that the User can open without the Read Only
warning.
 
When you share a folder, you need to specify how you're sharing the folder.
Users must have Change access (i.e.: they need Read, Write, eXecute and
Delete access) to the folder. This is because the first user in creates a
locking file (.ldb) in the folder, subsequent users update that locking
file, and the last user out deletes it.
 
Back
Top