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!

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.

"Artificer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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!
>

"Artificer" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> 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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/