|
Posted by Roger Abell [MVP] on March 1, 2006, 11:56 pm
If you were Registered and logged in, you could reply and use other advanced thread options
Due to the nature of the access you require (use of db in Access)
the combination of setting you want is not possible. They need
read/write to use Access and change database content. That
gives them ability to copy or delete the mdb.
The way one controls access is to use a middle-tier design so
that users themselves do not need permissions on the mdb
--
Roger Abell
Microsoft MVP (Windows Server : Security)
> Software: Windows 2003 Server / WinXP workstations
>
> I have a Microsoft Access database that our customer service dept needs to
> view, modify and update daily. I setup a share on our server to hold the
> database they are using, but I'm having difficulty setting up the
> permissions/security to allow for everyone to have the ability to modify
> (read/Write)the database files, but be unable to copy or move the
> database.
>
> Anyone have any ideas on how to do this?
>
> Thanks
> Roman
| 
XML site map