Very basic password system

[beuy]

Hey yo,

I am atempting to implment a password system by using the information storedf in a Table. It contains id (autonumber key) name (users name) and password (the password).

I want it to work like this,

The fourm opens on startup, the user enters their id and password, if it matches it logs them in, if not it returns an error message. However i also need to store that ID number for future use within the database (differnt user's have differnt order's, clients and apointments etc.) I considered doing this through the VBA script but im not too sure on how to do it. Any help with getting this to work would be greatly apreciated .

 

[trucktime]

Password

Check this link:

http://www.microsoft-accesssolutions.co.uk/login.htm

 

[GabrielR]

Great example. There is another one HERE, Passing global variables to do some nice tricks.