ADO and Database Access 2000 with Password 
Author Message
 ADO and Database Access 2000 with Password

Hi everybody,
I need help: I'd like to know what I've to add to the connection string if I've a
database with password (the database password is "pw"). My connection string is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TEST\test.mdb;Persist Security
Info=False"
Thank you.


Sun, 16 Nov 2003 04:28:45 GMT  
 ADO and Database Access 2000 with Password
My string
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBLocation &
conDataBaseName & ";Persist Security Info=False" & ";Jet OLEDB:Database
Locking Mode=1;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=" &
sDBpassword
            bDbLocated = True


Hi everybody,
I need help: I'd like to know what I've to add to the connection string if
I've a
database with password (the database password is "pw"). My connection string
is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TEST\test.mdb;Persist
Security
Info=False"
Thank you.



Sun, 16 Nov 2003 06:19:54 GMT  
 ADO and Database Access 2000 with Password
Actually you just need to add one thing to your connection string, a Jet
OLEDB:Database Password=pw section, as in this example;

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test1.mdb;Jet OLEDB:Database
Password=pw


Quote:
> My string
> strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBLocation &
> conDataBaseName & ";Persist Security Info=False" & ";Jet OLEDB:Database
> Locking Mode=1;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=" &
> sDBpassword
>             bDbLocated = True



> Hi everybody,
> I need help: I'd like to know what I've to add to the connection string if
> I've a
> database with password (the database password is "pw"). My connection
string
> is:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TEST\test.mdb;Persist
> Security
> Info=False"
> Thank you.



Sun, 16 Nov 2003 10:55:09 GMT  
 ADO and Database Access 2000 with Password
Fadli,

Please take a look at this Knowledge Base article.
Q191754 HOWTO: Open a Secured Access Database in ADO Through OLE DB
http://support.microsoft.com/support/kb/articles/q191/7/54.asp

HTH,

Peter



Sun, 16 Nov 2003 14:57:08 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. ADO Passwords for Access 2000 db's

2. ADO Passwords for Access 2000 db's

3. using vb to set and unset password for access 2000 database

4. connect DAO 3.6 from VB to Access 2000 (database set password)

5. access 2000 with database password, vb6, crystalreport 7

6. VB6 (SP4) Data Control - Access 2000 Password Database

7. access 2000 with database password, vb6, crystalreport 7

8. using vb to set and unset password for access 2000 database

9. Access 2000 set database password

10. set and unset password for a ms access 2000 database

11. access 2000 with database password, vb6, crystalreport 7

12. password of a Access Database 2000

 

 
Powered by phpBB® Forum Software