Tweet
How to access a secured Jet Database!
Hello,
how to access a secured Jet Database, thus I got it:
1.
file adodb.inc make with "PowerBASIC COM Browser" from Microsoft ActiveX Data Objects 2.xx Library.
for example from C:\Program Files\Common Files\System\ado\msado27.tlb (File, Open Library File..., mark everything into left windows, File, Save Interface to File...)
2. for example...
Access Database with user security: my_base.mdb
Access System database (C:\Program Files\Common Files\System\...): System.mdw <-- it can be copied in the other folder
User: I_am
Password: my_pass
Database connection string:
Enjoy!
how to access a secured Jet Database, thus I got it:
1.
Code:
#INCLUDE "adodb.inc"
for example from C:\Program Files\Common Files\System\ado\msado27.tlb (File, Open Library File..., mark everything into left windows, File, Save Interface to File...)
2. for example...
Access Database with user security: my_base.mdb
Access System database (C:\Program Files\Common Files\System\...): System.mdw <-- it can be copied in the other folder
User: I_am
Password: my_pass
Database connection string:
Code:
vSQL = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System database=C:\PBWin80\MyWork\SQL\System.mdw;Data Source=C:\PBWin80\MyWork\SQL\my_base.mdb;User Id=I_am;Password=my_pass;"
Comment