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