How to Prompt user at opening

D

Dib

Hi,

How do I prompt the user to enter name and password when the .adp is been
opened.

I have created a form with txtname and txtpassword, the connection is good,
but when I go to customer form the user is getting prompted again with the
SQL Server login.

Thanks
Dib
 
J

J Arty

Why do you wan't to do that, just let the user log in with the sql log in
and chack the useid with dbcCurrentUser
then set security according to the user id returned
 
D

Dib

Thanks
Dib

J Arty said:
Why do you wan't to do that, just let the user log in with the sql log in
and chack the useid with dbcCurrentUser
then set security according to the user id returned
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Express Login Prompt From Access 2007 ADP 1
SQL Username/Password Prompt Doesn't Appear 1
Log-In Screen with UserName and Password 4
.mdb or .adp which is best to use with SQL 2K 10
Remote NT Login not working 5
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Form Recordset Update Error when on network 3
View with criteria from form user in ADP!!! Help me! 3

Top