Cannot lock file

[jeffuk123]

Hello

I am have a customer who has a shared folder with an access 2003 database
file in it, on their server.

All users who access the file have the same active directory accounts i.e.
domain users.

9 of the users are part of a group who are to only have read-only
permissions to the access database file. 1 user has to have write permissions.

When the user with write permissions accesses the database, a .idl file is
created with a lock symbol next to it. None of the other users can access
this file until that user logs off.

What permissions are required on the share and on the NTFS in order that the
group of users can read the file but not write to it?

Kind regards to all,
Jeff

 

[Ed Metcalfe]

Hello

I am have a customer who has a shared folder with an access 2003 database
file in it, on their server.

All users who access the file have the same active directory accounts i.e.
domain users.

9 of the users are part of a group who are to only have read-only
permissions to the access database file. 1 user has to have write
permissions.

When the user with write permissions accesses the database, a .idl file is
created with a lock symbol next to it. None of the other users can access
this file until that user logs off.

What permissions are required on the share and on the NTFS in order that
the
group of users can read the file but not write to it?

Kind regards to all,
Jeff

Jeff,

I believe the users must have write permissions to the directory in order to
record their connection in the LDB file (if one has already been created).

You would be best off controlling their permissions to the database via MS
Access user-level security than through directory permissions.

Ed Metcalfe.

 

[jeffuk123]

Thanks for your response.

Only one user requires write permissions, all other users require only read
permissions. I wondered if there was a way of allowing this, as it doesn't
seem to be as simple as enabling or disabling read or write permissions.

I haven't used the user-leve security within Access, can you provide more
info on this, how to access it or provide the approprirate permissions?

Thankyou
Jeff

 

[Ed Metcalfe]

Thanks for your response.

Only one user requires write permissions, all other users require only
read
permissions. I wondered if there was a way of allowing this, as it doesn't
seem to be as simple as enabling or disabling read or write permissions.

I haven't used the user-leve security within Access, can you provide more
info on this, how to access it or provide the approprirate permissions?

Thankyou
Jeff

Jeff,

The user-level security wizard is pretty good in Access 2000 and later
versions. I rarely use it but if I remember correctly it comes with a set of
predefined access levels, I'm pretty sure one of which is a read-only user.
The wizard will give you options of creating one or more user groups (with
necessary permissions) and assign your users to it.

Make sure you take a backup of your database before you use it. I've never
had any problems, but it's better to be safe than sorry.

If you want more details on user-level security in MS Access there are loads
of tutorials and FAQs online. One of the best I've found is available on
www.tek-tips.com (it's free to join and I am in no way affiliated with the
site, other than being a member there - I'm not using this as an excuse to
advertise )

Ed Metcalfe.

 

[jeffuk123]

Many thanks Ed,

I'll have a look at it.

Jeff

Jeff,

The user-level security wizard is pretty good in Access 2000 and later
versions. I rarely use it but if I remember correctly it comes with a set of
predefined access levels, I'm pretty sure one of which is a read-only user.
The wizard will give you options of creating one or more user groups (with
necessary permissions) and assign your users to it.

Make sure you take a backup of your database before you use it. I've never
had any problems, but it's better to be safe than sorry.

If you want more details on user-level security in MS Access there are loads
of tutorials and FAQs online. One of the best I've found is available on
www.tek-tips.com (it's free to join and I am in no way affiliated with the
site, other than being a member there - I'm not using this as an excuse to
advertise )

Ed Metcalfe.