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 / Multiuser / Networking / August 2004

Tip: Looking for answers? Try searching our database.

locking records according to user

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 27 Aug 2004 06:55 GMT
Hello everyone,

I am using Access 2002, but am programming a database for
Access 2k. The database is split with user-level security.
The database is to be used in multiple locations, either
with the back-end on a cetral server (preferably, but
still not quite clear) or otherwise using replicas.

Now for the hard part:
I want to make the database so that all regular users can
only modify records which they themselves have created.
A certain group of users (for example the admins group) is
to have access to all records regardless.

What is the best way to approach this?

TIA

Chris
Nikos Yannacopoulos - 27 Aug 2004 08:03 GMT
Chris,

To the best of my knowledge, Access security cannot handle that. What you
need to do is use a field to store the user who created a record in each
table you need this functionality on (Application.CurrentUser is the way to
get the user logon name on a secured database), and then provide access to
the tables through queries filtering on the username.

HTH,
Nikos

> Hello everyone,
>
[quoted text clipped - 15 lines]
>
> Chris
 
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.