I'm trying to access a password protected Access 97 database using the Jet
Engine in VB5/6 with Data-controls and found no way of prividing the
username / password.
Any ideas?
Thanks in advance,
Martin
by Martin Baumgartne » Mon, 14 Dec 1998 04:00:00
Any ideas?
Thanks in advance,
Martin
by Wendy Whitbec » Tue, 15 Dec 1998 04:00:00
HTH
Wendy
>Any ideas?
>Thanks in advance,
>Martin
by Dougie Henderso » Tue, 15 Dec 1998 04:00:00
If you've simply used a database password (as opposed to different users)
then
when you're opening the database use a connect string of ";PWD=mypassword"
(note the semicolon - very important).
If you're trying to connect as a specific user then use a connect string of
"UID=myuser;PWD=mypassword" (replacing myuser and mypassword
appropriately).
Hope that helps,
Dougie Henderson.
>Any ideas?
>Thanks in advance,
>Martin
1. Problem using Access 97 Password protected Database in VB
Hello!
I have a problem connecting Access 97 password protected database file
through DataControl in Visual Basic 6.0. The problem is DataControl couldn't
have the password property so my database couldn't been open by VB, when it
is password protected. Can anybody resolve my Problem
Saleem
2. Cube back up
3. Opening password protected Access 97 databases
5. Connection String to password protected Access 97 database
7. Jet engine loses 10 records when first opening an Access 97 database
8. Newbie question - Problem connecting Java to password protected Access 97 db
9. Openning From VB6 A Password Protected Access 97 File
10. Password-protected Access 97 DB
11. Problem using Access 97 database password in Visual Basic 6.0
12. Problem using Access 97 Database Password in Visual Basic 6.0