ADP login by default

I have a ADP project under MS access 2k as a front end of an SQL Server 2005 Backend. When I start my application, the login dialog box appear but the default username is the one that I used to create the application.

I would like to set the default login to the last username who succesfully log in (or something like that)

I know that I can change the login when I click on  File; Connexion. but in this case the new login become the default login.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leigh PurvisDatabase DeveloperCommented:
Could you not just distribute it without *any* login credentials set - and then the users go in from cold.
monsieurxAuthor Commented:
For sur it will be better than my login as default, but how can I set the default login to an empty value

I tried by file; connexion and it's imposible to let the login field empty because it give me an error that say something like "Impossible to connect to database"

Leigh PurvisDatabase DeveloperCommented:
If you remove the connection altogether - no login - no server no database.
Then set them all in code as your app starts up the first time.
(Just an normal ADO connection string - set that as the application's connection)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Leigh PurvisDatabase DeveloperCommented:
By way of example

Dim strconn As String

strconn = "Provider=SQLOLEDB.1;Data Source=YourServer;User ID=UN;Password=PW;Initial Catalog=YourDatabase;"
CurrentProject.OpenConnection strconn
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.