Logging In

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Matt said:
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
Click to expand...

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.
 
Thank you Joseph.

I had better get practicing!

Joseph Meehan said:
Matt said:
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
Click to expand...

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.
Click to expand...
 
Back
Top