Hi,

I'm using Access to create some reports that use tables linked to SQL database. I'm prompted for a SQL password every time I run a query or report and wanted to automatically assign the UID and Password so the user doesn't have to enter a password. I've played around with this code but I think I need DAO commands?

Can someone tell me how to change this ADO command into DAO command

Set cnAptify = New ADODB.Connection
With cnAptify
.ConnectionString = "DSN=DevAp;UID=sa;PWD=P123;"
.Open
End With


Thanks much.