SQL Server Connection String - Access adp project (1 Viewer)

[ak_ls]

The following VBA code that connects to SQL Server in an Access adp project works without any problem on my computer but does not work on another user's computer.

CurrentProject.CloseConnection

ConStr = "Provider=sqloledb;Data Source=UK009125D\SQLExpress;Integrated Security=SSPI;Initial Catalog=MyDatabase;User ID=xxxxxxxx;Password=yyyyyyyy"

CurrentProject.OpenConnection ConStr


Is there some mistake in the above VBA Code? Please help.

With Thanks
Ashok

 

[SQL_Hell]

The connection string seems to use intergrated security, but then you are specifying a user name and password, if you are using windows authentication then you dont need to specify the username and password.

Please see my FAQ

http://www.access-programmers.co.uk/forums/showthread.php?t=158259

 

[ak_ls]

Thanks SQL Hell.

As pointed out by you, I have removed "Integrated Security=SSPI" from the connection string and it is now working. The database authentication is through SQL server and not through Windows.

Ashok

 

[SQL_Hell]

cool Glad you got it working.