Access 2002 Unwanted Read Only Attribute

D

Dave 10001

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
 
D

Dave 10001

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.
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top