ADO connect not using UID in connect string

R

Robert

I have the following connect string for an ado open:
Driver={Microsoft Access Driver (*.mdb)};Dbq=my.mdb;Uid=robert;Pwd=xyz;
When I try to execute the open it says there are no read permissions. I
have given read permissions to everthing except user Admin. User admin has
no permissions. How can I get the ADO to use the user in the connect string?
 
S

smk23

Try this connection string. It eliminates the need for UID and PWD in the
string:

Conn="Provider=sqloledb;Data Source=YourServer;Initial
catalog=YourDBName;Integrated Security=SSPI;"

HTH,
Sam
 
R

Robert

I want to use UID and PWD because I do not want user admin (the default) to
have access.
 
Top