<div>
Could you not just distribute it without *any* login credentials set - and then the users go in from cold.
</div>


Could you not just distribute it without *any* login credentials set - and then the users go in from cold.

<div>
For sur it will be better than my login as default, but how can I set the default login to an empty value<br />
<br />
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 &quot;Impossible to connect to database&quot;<br />
<br />
thanx<br />

</div>


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"

thanx


<div>
By way of example<br />
<br />
Dim strconn As String<br />
<br />
strconn = &quot;Provider=SQLOLEDB.1;Data Source=YourServer;User ID=UN;Password=PW;Initial Catalog=YourDatabase;&quot;<br />
CurrentProject.OpenConnect<wbr />ion strconn
</div>


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

<div>
<div class="content wysiwyg-content">
<br />
<br />
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. <br />
<br />
I would like to set the default login to the last username who succesfully log in (or something like that)<br />
<br />
I know that I can change the login when I click on &nbsp;File; Connexion. but in this case the new login become the default login.<br />
<br />
Thanx<br />

</div>
</div>


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


ADP login by default

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.