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?

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

"Robert" wrote:

> 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?
>

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

"smk23" wrote:

> 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
>
> "Robert" wrote:
>
> > 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?
> >