Connecting To An Access Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas Kerr - 26 Aug 2005 19:21 GMT

When I set up a Data Link to an Access database, I have a problem if the
database has a password.

I can connect if I use Microsoft OLE DB provider for ODBC Drivers but can
not when I use the Microsoft Jet 4.0 OLE DB provider.

It would seem to me that the use of the Jet method would be the preferred
one of choice. Any thoughts or ideas on this would be greatly appreciated.

Tom

Reply to this Message

Winguy - 26 Aug 2005 20:36 GMT

> When I set up a Data Link to an Access database, I have a problem if the
> database has a password.
[quoted text clipped - 6 lines]
>
> Tom

That's something I jsut got done fighting with, too. It turns out that if a
*database* password is defined then one is *always* asked for it upon any
kind of connection, no matter what. Delete the database password and set up,
in the database Security section, for Users and their Passwords, instead of
using a database password. I'm pretty sure that one can not pass a
*database* password through the ADO connect string, under any circumstance,
but you certainly can pass the User and the User's Password as defined in
the database Security section. Also, you might have to specify (you can do
it in the connect string) which System.mdb file is being used (the path and
name for it) for the User/Groups and their Passwords. I hope that helps, and
I'm sure someone will correct me if I said anything inaccurately!

Reply to this Message

Thomas Kerr - 27 Aug 2005 20:38 GMT

Thanks for the reply. As I am new at database programming I am struggling a
bit with the concept. I have tried what you have suggested but haven't
gotten it correct yet. I have trouble with the structure/syntax of the
connection string.

Why is not possible to set up the parameters right in the data link setup
and the DE setup?

> > When I set up a Data Link to an Access database, I have a problem if the
> > database has a password.
[quoted text clipped - 18 lines]
> name for it) for the User/Groups and their Passwords. I hope that helps, and
> I'm sure someone will correct me if I said anything inaccurately!

Reply to this Message

Paul Clement - 29 Aug 2005 15:01 GMT

¤ Thanks for the reply. As I am new at database programming I am struggling a
¤ bit with the concept. I have tried what you have suggested but haven't
¤ gotten it correct yet. I have trouble with the structure/syntax of the
¤ connection string.
¤
¤ Why is not possible to set up the parameters right in the data link setup
¤ and the DE setup?

Look on the All tab. There is a property call Jet OLEDB:Database Password where you can specify the
database password.

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

VB Forum / Database Access / August 2005

Connecting To An Access Database