Login Form

[Sean]

I have made a db for inventory control, which has many different features,
PO's, job costing, employees, assets, etc. I need to be able to track who
has been using the db and when by haveing them log in to it. I need to keep
a record of this. I have made a starting form for the login, with a table
called 'Login'. The table has field names of UserID, Password, Date, and
Time. Thanks for any help you can give me in advance.

Sean

 

[Rick Brandt]

I have made a db for inventory control, which has many different features,
PO's, job costing, employees, assets, etc. I need to be able to track who
has been using the db and when by haveing them log in to it. I need to keep
a record of this. I have made a starting form for the login, with a table
called 'Login'. The table has field names of UserID, Password, Date, and
Time. Thanks for any help you can give me in advance.

Just use the Startup options to open your Login form when the app is
launched and then use DLookup or a RecordSet to determine if a valid
UserName and Password was entered. If so, open your app normally,
otherwise quit.

If you are just logging users this will be ok, but be aware that if you
want any type of security (since you are including passwords) that anything
"home-grown" like this will be trivial to bypass for someone who knows
anything about Access. Access has built-in user level security that will be
much more robust than anything you can build on your own, but it comes at
the price of being fairly complex to set up (correctly) and adds a lot of
maintenance to the application. If you want to go that route there is an
FAQ on Access security available at MS site that you should read about a
dozen times through before you attempt it (on a copy of your file first).

If you really just want "who used the app and when", there is a code
example at the link below that will automatically give you the network
login name of the person running the program. Then you don't even need a
login form.

http://www.mvps.org/access/api/api0008.htm

 

[Sean]

Thanks for the help on this.

Sean

Just use the Startup options to open your Login form when the app is
launched and then use DLookup or a RecordSet to determine if a valid
UserName and Password was entered. If so, open your app normally,
otherwise quit.

If you are just logging users this will be ok, but be aware that if you
want any type of security (since you are including passwords) that anything
"home-grown" like this will be trivial to bypass for someone who knows
anything about Access. Access has built-in user level security that will be
much more robust than anything you can build on your own, but it comes at
the price of being fairly complex to set up (correctly) and adds a lot of
maintenance to the application. If you want to go that route there is an
FAQ on Access security available at MS site that you should read about a
dozen times through before you attempt it (on a copy of your file first).

If you really just want "who used the app and when", there is a code
example at the link below that will automatically give you the network
login name of the person running the program. Then you don't even need a
login form.

http://www.mvps.org/access/api/api0008.htm