Announcement

Collapse
No announcement yet.

How to access a secured Jet Database!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to access a secured Jet Database!

    Hello,
    how to access a secured Jet Database, thus I got it:

    1.
    Code:
    #INCLUDE "adodb.inc"
    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:
    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;"
    Enjoy!
    Yours sincerely

  • #2
    Usefull URL re. ADO connection strings: http://www.connectionstrings.com/

    Comment

    Working...
    X