Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Access a MS Access database over network.

paulmorrisonpaulmorrison Member Posts: 127
What's the trick? How do you make a MS Access database read only for some user and full permissions for others using the computer accounts from either the domain or those on the server. For most other files, when you set either a file or a folder to read only, then the user can only read the document and not change it. When you do this to an Access database, access/use of the database is just flat out denied unless you have full permissions. What am I missing here?

Comments

  • dokken2dokken2 Member Posts: 532
    : What's the trick? How do you make a MS Access database read only for some user and full permissions for others using the computer accounts from either the domain or those on the server. For most other files, when you set either a file or a folder to read only, then the user can only read the document and not change it. When you do this to an Access database, access/use of the database is just flat out denied unless you have full permissions. What am I missing here?
    :

    one issue is that when an access file, mydb1.mdb, is opened - access needs to open and write to the record locking file mydb1.ldb [and system.ldb if the system.mdw workgroup is located on network]. readonly permission will not allow creating those 2 files.

    your options are to provide write access to the folder or have a strategy to copy the file [or workgroup] to the users local drive.
Sign In or Register to comment.