Access to SQL Server

H

Huey

If you set the connection string to an empty string, Access will not prompt
for user name and password. You can then create your own and make the
connection.

CurrentProject.OpenConnection ""

Remember, to set the connection back to an empty string when app closes. I
do this with a hidden form. The only time this hidden form closes is then
app closes, which is where I have placed the code for resetting the
connection string. It is not fool proof but works fine for my use.

hope this helps.
 
V

vichet

Hi All;

Generally when access connect to sql server, it prompt for username and
password (that form is of ms access).

But i want to make my own form, so that i can make up it

Please help

Vichet
 
Top