UN login to access db passed to another form

[pmsbony]

I am creating a basic call loggin app and need to get users to log in to it.

I have a users table in an access 2000 db. I want to get people to log in to the db with UN/PW supplied by me. I can find lots of info about accessing a pw protected db but little about directly querying a table to check the logon credentials.

Also once a user has logged on I need to pass the name of the user logged on in to the next form that opens up.

I am sure this should all be very simple, but for a newbie such as myself it is all a bit tricky. Any help would be gratefully recieved.

peter

 

[mshetti]

Dear Peter

Try this...

Create a table as users in ur access DB which can have cols like UserName and PassWD

Get a connection to the DB first and then ask the user for his username and passwd then query the users table like...

Select Count(UsedName)
From users
Where username = ''
and passwd = '' ==> write the values from the text boxex in between the quotes.

Hope this help.

Regards
Mahesh
mshetti@yahoo.com