Restricting access to records

  • Thread starter Thread starter gavin
  • Start date Start date
G

gavin

I have an Access database to record how much time colleagues have spent
working on various projects. Users access this database on a shared network
drive. All users have the same permissions to this file via the shared drive
but I haven't set security via Access's security features - I have never
attempted this before but have read the Help files.

I know I can set various permissions for individuals and groups but the
question is can I restrict users to only being able to read/edit records
which they have entered? There is a field in the database table which stores
the user ID for each record (it records the network logon) - I don't know if
that is significant or not!

Thanks for any help.



Gavin
 
You do not have to use the security features of Access to
accomplish this. I will assume that you are currently
opening a form to all of the records. Just limit the
recordset for the form to those where the User ID is
equal to the current user.

HTH

Byron
 
Many thanks for the reply Byron. I'm glad I won't have to use Access's
security features to achieve this but could you tell me how to limit the
recordset of the form to those where the User ID = the current user?

I assumed that the form should have a Property called Recordset but having
scrolled carefully through the list it appears that it doesn't. I have no
idea how to proceed with this - I would greatly appreciate some more help!


Regards,



Gavin
 
Gavin,

Sorry it has taken a little while to get back to you. If
you need more assistance with this, email me directly and
I will send you some code that will read this info.

You can email me at: (e-mail address removed)

Just remove the NOSPAM from the above address.

Byron
 
Hi Byron,
I have just emailed you but the message has bounced back to me. Maybe you
could email me at gavin.robertsonATsalford.gov.uk (obviously inserting the
AT symbol in the right place!).


Many thanks for your help.



Gavin
 
Back
Top