access + VBA question

houssam_ballout

New Member
hello all
I have a database (it is the application), and it contain the table for users that are trying to access the system (application), I have the main form,so based on the username and password, I would like to give each one a specific privilege, so how could I use the code BUILDER with VBA, to access the table of the user and check that the data held inside the controls (the 2 edit boxes ) matches a specific row in the table..???

thanks
 

Cromewell

Administrator
Staff member
You would have a log in type form that has a button that runs a query to check the table for you then the button opens what ever other controls the user has.
 
Top