OLE DB connection with password

[Laphan]

Hi Guys

I know I've moaned about this recently, but all I want is a copy and paste
example of the following:

MyVar = OLEDB connection to an Access DB with a database password

Can you help??

A helpful poster told me that my connection attempt was OK, but my params
further down the line might be at fault. Are there differences in ADO
Connection, Command & Recordset code between the ODBC connection and the OLE
DB connection? If there are, what are the fundamental ones?

Many thanks.

Rgds

Laphan

[Aaron Bertrand - MVP]

What does "at fault" mean? Could you show your connection string, and the
error you're receiving?



"Laphan" <news@FrozenNOSPAMMoles.co.uk> wrote in message
news:bm4k0j$pek$2@sparta.btinternet.com...

> Hi Guys
>
> I know I've moaned about this recently, but all I want is a copy and paste
> example of the following:
>
> MyVar = OLEDB connection to an Access DB with a database password
>
> Can you help??
>
> A helpful poster told me that my connection attempt was OK, but my params
> further down the line might be at fault. Are there differences in ADO
> Connection, Command & Recordset code between the ODBC connection and the

OLE

> DB connection? If there are, what are the fundamental ones?
>
> Many thanks.
>
> Rgds
>
> Laphan
>
>

[Bob Barrows]

Laphan wrote:

> Hi Guys
>
> I know I've moaned about this recently, but all I want is a copy and
> paste example of the following:
>
> MyVar = OLEDB connection to an Access DB with a database password
>
> Can you help??
>
> A helpful poster told me that my connection attempt was OK, but my
> params further down the line might be at fault. Are there
> differences in ADO Connection, Command & Recordset code between the
> ODBC connection and the OLE DB connection? If there are, what are
> the fundamental ones?
>
> Many thanks.
>
> Rgds
>
> Laphan

I repeat: your connection string is fine. Your problem stems from having
table or fields with reserved words as their names. I even gave you a link
to Aaron's FAQ page that listed the reserved words. If you need further
help, you've got to supply us with some more code to look at. Let's see your
SQL statement.

Bob Barrows