About Jet DB connecting strings and encrypted strings
problem:
About Jet DB connect strings, and how to write the string of the MDB file after the encrypted string ADO? How to write after encryption?
Reply:
The Access database is delayed by three kinds of Access XP as Example 1. Tools -> Security -> Encrypted / Decrypting Database, there is no need to change 2, tool -> security -> set the database password, open the password is 1 when the password is opened.
"Provider = microsoft.jet.OLEDb.4.0; data source = c: /1.mdb; user ID = admin; password =; jet oledb: Database password = 1" can also be used
"Provider = microsoft.jet.Oledb.4.0; data source = c: /1.mdb; user ID = 'admin'; password =; jet oledb: Database password = '1'" 3, tool -> security -> users Group and privileges .... User named admin Password for the RR user group file as c: /system.mdw, need to 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: /System.mdw "Can also be used
"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: /system.mdw "
Please refer to the forum on related links: http://access911.net/bbs/uploadFile/2003342119632505.htm
