VBA + MS ACCESS

[houssam_ballout]

hello all
I have a table in MS Access, and I am using VBA to access records ( I Am
newbie on learnig VBA), I have a table on ms access called USer, which
contains the username and passwords that give privilege for users to access
the database
I have created a form, and I have drop on it 2 edit boxes which are the
username and password,
my question is here:
HOw could search the table for records that matches what the user has
entered into the text box with records in the table.....

THanks in advance

 

[Jerry Whittle]

Why are you reinventing the wheel? Access already has very robust user level
security. It's somewhat difficult to set up properly, but works well once you
do.

If you create your own security, it will probably have more holes in it than
Swiss cheese. Something as simple as holding down the Shift key while
starting Access will probably bypass it.

 

[houssam_ballout via AccessMonster.com]

well I have looked about that
but I want the administrators of the software to be able to add users and so
different users can login to the software with each has username and password