DB Password

[mrgismo]

Hi,

I've secure my database with an admin Password. Now i want to access the Database external via VB. How can i tell Access the password for the database?
I've tried the described method, putting the password in the connect property of the bound data control, but it doesn't work.

Any Ideas?

[H.Q.Cuong]

Hello,
If u use ADO and OLEDB to access Access DB, use the property "Jet OLEDBatabase Password" of the Jet OLEDB.

[mrgismo]

I'am using VB5 with the normal Data Control i'll bind it at runtime to an password protected Access Database. The Data Control does not have an property password

[H.Q.Cuong]

See the Connect property in the MSDN !

[mrgismo]

I put in the connect Property "UID=admin;PWD=test"

I've tried some other variations but i always get the Message "Invalid Password".
The Password was set directly in Access

[smalig]

Hi,

see answer on
http://members.tripod.com/smalig/vb/079913.html

Best Regards

Try the following:

Dim db As Database
pwwd = password.Text

Set dbs11 = OpenDatabase("c:\db.mdb", False, False, ";Pwd=" & pwwd)

I ran into the same problem you are and I went round and round with it. It didn't work for me until I set the Password equal to a variable then used the opendatabase method with the aforementioned arguments.

Hope this helps.

[mrgismo]

OK :-)

The result now is that i get the Errormessage "ODBC Connectio to Database xxx failed"

I don't know what i can do anymore :-(((