Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / October 2006

Tip: Looking for answers? Try searching our database.

Securing the back end of the database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin Hopkins - 28 Oct 2006 19:12 GMT
Hello,

I have a database that is split, with the front end copied to users
personnel area of our IT system.

Access to records is define by a unique logon which gives them user or admin
or superuser access. User only lets the user see his or her records. Admin
allows for all records in his/her deptparment. Superuser allows all records.

This works well, but having difficulty with some users accessing backend
with comments return "cannot lock file".

How can I set up the network backend permissions, which resides inna public
area of the network, so to allow all access to databse but stop anyone
deleting the back end.

Hope the above is clear.

Thanks.

Martin hopkins
Granny Spitz - 28 Oct 2006 19:39 GMT
> How can I set up the network backend permissions

Give all users read, write, create and delete permissions on the database
folder.

> so to allow all access to databse but stop anyone
> deleting the back end.

Set up the users as part of a windows group and only allow administrators and
that group to have access to that folder.  This ensures only authorized
people can use the database.  If anyone deletes the file, tell them they'll
be fired.  They'll be more careful but you *can't* prevent them from deleting
the file if you *must* allow them to use it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.