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

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


.

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


.

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


.



.

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


.



.