Logging In

[Guest]

I currently have a database in Access 2003 with user permissions and
passwords. When the relevant user logs in they go to the form and assign
themselves to a job.
However, at the moment it would be possible for them to sign in and assign a
job to another worker.

Is it possible to create a piece of security where a user logs in and can
only assign him/her self from the drop down list within the form?

Any help would be much appreciated,
Matt

 

[Joseph Meehan]

I currently have a database in Access 2003 with user permissions and
passwords. When the relevant user logs in they go to the form and
assign themselves to a job.
However, at the moment it would be possible for them to sign in and
assign a job to another worker.

Is it possible to create a piece of security where a user logs in and
can only assign him/her self from the drop down list within the form?

Any help would be much appreciated,
Matt

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

Thank you Joseph.

I had better get practicing!

I currently have a database in Access 2003 with user permissions and
passwords. When the relevant user logs in they go to the form and
assign themselves to a job.
However, at the moment it would be possible for them to sign in and
assign a job to another worker.

Is it possible to create a piece of security where a user logs in and
can only assign him/her self from the drop down list within the form?

Any help would be much appreciated,
Matt

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.