Login and passwords in a database w/o using user level security

  • Thread starter marn826 via AccessMonster.com
  • Start date
M

marn826 via AccessMonster.com

Hi Guys,

What I am trying to do is get around creating users and group level security
because I've never used it before and I don't know if I have time to learn
something that is as challenging as securities seem to be.

Is there a way to have a login and password form to identify the user and
have the user's name from the login form filter a form/query so that only
information pertaining to that user is available to him/her ( there will be
approximately 12 users). Also have a way for their manager to be able to
access all the data that the users either edited or added in a summarized
report?

The database will only have a table that holds all the data that the user's
entered/edited and a query that filters data per users and the ability to use
that main table as the base for the summary report for the manager. Also I
don't want the users to be able to access any data but what pertain to them.

I hope I've given you enough information.

Thanks for any advice you can give me!

Nita
 
A

Allen Browne

Nita, you create create an unbound dialog form that opens when your
application begins, accepts the user name and password, and compares against
values in a table. When the user clicks Ok, don't close the form, but set
its Visible property to No.

As each form is loaded, you can then read the user name from the hidden
form, and set the RecordSource of the form so it shows only the records for
that user. You will need to understand some VBA to implement that.

For your 2nd question, Access does not record a log of changes, nor expose
who created and last changed the record and when. You can add 4 fields to
your table, e.g.:
CreatedOn Date/Time when the record was created.
CreatedBy Text user who created the record
UpdatedOn Date/Time when the record was last changed
UpdatedBy Text use who last changed record.
You can then use the BeforeUpdate event of your form to populate these
fields. (Note that this only works if the data is changed through a form.)

If you wanted a full history of all inserts, deletes, and edits, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
 
M

marn826 via AccessMonster.com

You are lifesaver thank you so much. This is exactly what I needed. You is
THE MAN!!!!

Allen said:
Nita, you create create an unbound dialog form that opens when your
application begins, accepts the user name and password, and compares against
values in a table. When the user clicks Ok, don't close the form, but set
its Visible property to No.

As each form is loaded, you can then read the user name from the hidden
form, and set the RecordSource of the form so it shows only the records for
that user. You will need to understand some VBA to implement that.

For your 2nd question, Access does not record a log of changes, nor expose
who created and last changed the record and when. You can add 4 fields to
your table, e.g.:
CreatedOn Date/Time when the record was created.
CreatedBy Text user who created the record
UpdatedOn Date/Time when the record was last changed
UpdatedBy Text use who last changed record.
You can then use the BeforeUpdate event of your form to populate these
fields. (Note that this only works if the data is changed through a form.)

If you wanted a full history of all inserts, deletes, and edits, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
What I am trying to do is get around creating users and group level
security
Click to expand...
[quoted text clipped - 23 lines]
Nita
Click to expand...
Click to expand...
 
Top