Syntax for password protectd database...

[Matthew Wells]

Hello,

I have an ADO connection object connected to an external ms access password
protected database. I am trying to execute a delete statement from that
object on a table in my currentdb. Seems strange I know, but I have to do
it this way. My currentdb is NOT password protected. When I execute:

Delete * from table1 IN "C:\abc.mdb"

I get an "Invalid Password" error.

My ado connection object to the password protected database is already open
so I don't think it's that password, and my currentdb has no database
password so I'm a bit confused. Deos anyone know the correct syntax?

Thanks.

Matthew Wells
MW****@FirstByte.net

[Steve]

I'm not the smartest guy for this one, and I've never connected to an
external database to execute a query on the local one (letting you know
up front), but here's something to at least start with:

It almost seems as though your statement is creating a new connection
to try and execute your DELETE statement. Perhaps check to make sure
you don't have more than one ADO connection object referenced?

You may also want to re-check your connection string.
http://www.connectionstrings.com has a whole buch of
syntactically-correct connection strings in different permuatations
(i.e. OLE DB connection string with password, without password, with
trusted connection, etc).

[Matthew Wells]

I will also be using "Insert Into 'table in local.mdb' Select * from table1
in 'password protected.mdb'". My connections strings are fine. I have an
ado connection open for my local mdb, it's the syntax to select from the
password protected mdb that's got me stuck.

"Steve" <th*********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I'm not the smartest guy for this one, and I've never connected to an
external database to execute a query on the local one (letting you know
up front), but here's something to at least start with:

It almost seems as though your statement is creating a new connection
to try and execute your DELETE statement. Perhaps check to make sure
you don't have more than one ADO connection object referenced?

You may also want to re-check your connection string.
http://www.connectionstrings.com has a whole buch of
syntactically-correct connection strings in different permuatations
(i.e. OLE DB connection string with password, without password, with
trusted connection, etc).