Restrict users from accessing records created by other users

[Guest]

When two users share an mdb file, I want to restrict one user from accessing
/ modifying / deleting records created by another user. I've a table that
stores User IDs, Passwords and Access levels granted to them by the Admin
(not windows Admin). I also have a login form that checks User ID and
Password. I'm not comfortable with using Windows WorkGroup file (also, not
sure it can be done). I want to use a VBA module native to MS Access (Xp).

Any help as to what steps should I take to achieve this is greatly
appreciated.
Thanks a lot.

 

[Guest]

I forgot to mention: Database window is hidden from users. The restriction
applies to retrieval of data through forms, queries or reports only.

 

[Guest]

Since you have the user's id you can set your forms' filters to include only
records created by the user provided you have a field in your recordset that
is the user's id.

 

[Tim Ferguson]

. I'm not comfortable with using Windows WorkGroup file (also, not
sure it can be done). I want to use a VBA module native to MS Access
(Xp).

Frankly, any security measure you try to program in VBA can be walked
past by even a moderately competent user; and, unless you are really,
really good, it's likely to break accidentally anyway.

Yes, you can impose this kind of limitation using Access user-level
security using RWOP queries. It's well documented amongst all the other
information on how to create and maintain a secured database, and you
will need to read all of this in order to know what you are doing before
setting out.

The suggestion from most people here is that any other method will be
more trouble and cost to create than any results it will bring you.

Sorry!
Best wishes

Tim F

 

[Guest]

Thanks. That's what I have been trying too. But, I must confess I didn't
figure out how to store & pass the UserID to the filters each time a
different user logs in.

 

[Guest]

Thanks Tim.

I will definitely have a go at this, but only after "I know what I am doing"
before setting out. It may take time but as you said, it is worth giving a
try.