Connection strings for Jet db, and encrypted strings

Encryption


the connection string for Jet db and the encrypted string





 





question:





the connection string for Jet db and the encrypted string


How do you write strings for ADO connection mdb files?


how to write after encryption?


 





Answer:





Access database encryption is divided into 3 kinds


The following for an example of Access XP








1, Tools-> security-> encryption/decryption database, open without any changes





2, Tools-> security-> Set the database password, open the password is 1 to open the use of


"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb; User id=admin; password=; Jet oledb:database password=1 "





can also use


"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb; User id= ' admin '; password=; Jet oledb:database password= ' 1 '








3, tool-> security-> user Group and permissions ..., user name is admin password is RR user group file is c:ystem.mdw, need to use
when open

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb; User id=admin; PASSWORD=RR; Jet oledb:database password=1; Jet oledb:system database=c:ystem.mdw "





can also use


"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb; User id= ' admin '; Password= ' RR '; Jet oledb:database password= ' 1 '; Jet oledb:system database=c:ystem.mdw "








 











please refer to the relevant link address on the forum:


http://access911.net/bbs/UpLoadFile/2003342119632505.htm