ADP Custom Logon Form?

[Artificer]

I created an Access ADP using SQL Server authentication. Now (of
course) whenever the application starts it prompt me for the user name
and password (the desire behavior in my case). I want to know if I
can create a custom logon form to replace the one that access shows me
by default!

 

[Pat Hartman \(MVP\)]

I'm not sure how to do this in an .adp ( I never use them) but I know how to
do it in an .mdb. I'm guessing that the method would be the same. You can
create an unbound login form as the first form to open. In this form, you
would collect their user ID and password and create the necessary connection
string to the database and open the connection via ADO.

 

[David W. Fenton]

I created an Access ADP using SQL Server authentication. Now (of
course) whenever the application starts it prompt me for the user
name and password (the desire behavior in my case). I want to
know if I can create a custom logon form to replace the one that
access shows me by default!

You might find better answers in the newsgroup devoted to ADPs.