If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Restricting access to records
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 |
#2
|
|||
|
|||
Restricting access to records
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 -----Original Message----- 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 . |
#3
|
|||
|
|||
Restricting access to records
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 "Byron" wrote in message ... 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 -----Original Message----- 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 . |
#5
|
|||
|
|||
Restricting access to records
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 "Byron" wrote in message ... 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: Just remove the NOSPAM from the above address. Byron -----Original Message----- 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 "Byron" wrote in message ... 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 -----Original Message----- 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 . . |
Thread Tools | |
Display Modes | |
|
|