I have created an Access2K front end application that connects to a
SQLServer2K backend. I use this vba code to create the connection from
the Access app:
Dim strConnect As String
'make sure all previous connections are closed:
CurrentProject. OpenConnection "Provider="
'create new connection string to server:
strConnect = "PROVIDER=SQLOL EDB.1;INTEGRATE D SECURITY=SSPI;P ERSIST
SECURITY INFO=FALSE;INIT IAL CATALOG=Databas eName;DATA
SOURCE=ServerNa me"
CurrentProject. OpenConnection strConnect
Everything functions.
The problem is the users cannot make the connection if they are not
part of the local admins group on the server. As soon as they are
removed from the local admins group their connections fail.
The Access front end is using Windows NT Integrated security.
How do I remedy this?
SQLServer2K backend. I use this vba code to create the connection from
the Access app:
Dim strConnect As String
'make sure all previous connections are closed:
CurrentProject. OpenConnection "Provider="
'create new connection string to server:
strConnect = "PROVIDER=SQLOL EDB.1;INTEGRATE D SECURITY=SSPI;P ERSIST
SECURITY INFO=FALSE;INIT IAL CATALOG=Databas eName;DATA
SOURCE=ServerNa me"
CurrentProject. OpenConnection strConnect
Everything functions.
The problem is the users cannot make the connection if they are not
part of the local admins group on the server. As soon as they are
removed from the local admins group their connections fail.
The Access front end is using Windows NT Integrated security.
How do I remedy this?