Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Bucharest, Romania

    Red face Unanswered: VB5 and Access2002 for encrypted mdb file does not work

    Problem : I used the security wizard on an .mdb file. My previously working connection from VB5/ADO2.5 isn't working anymore.

    (A) Thru SQLOLEDB :

    Connection string = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\DataStore\Kukumatz.mdb; "
    strSca = strSca & "Initial Catalog=Students; User Id=Sori; Password=alfabeta; "

    I get the following error :

    "Multiple step OLE DB operation generated errors."

    (B) Thru ODBC (with a registered DSN) :

    Connection string = "DSN=Tilda; UID=Sori; PWD=alfabeta; Initial catalog=Students "

    I get :

    "Could not find file (unknown)"

    although I indicated the database name when configuring the DSN.

    What am I doing wrong ??



  2. #2
    Join Date
    Aug 2003

    Re: VB5 and Access2002 for encrypted mdb file does not work

    What exactly di you do with the Security Wizard? If you set a database password, and the database is not workgroup protected, the connection string should be:

    Connection string = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\DataStore\Kukumatz.mdb;Jet OLEDBatabase Password=mydbpassword;"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts