Results 1 to 4 of 4

Thread: Password

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    116

    Exclamation

    Hi,

    I am trying to open an Access97 database, but
    keep getting the Error: Not a valid password
    even though the password is correct.

    Set dbsCustomers = OpenDatabase(“c:\Customers.mdb”, False, False, ";pwd=thepassword123")

    Any suggestions?

    Thanks
    0101011001000010
    01101111011011100110110001101001011011100110010101110010

  2. #2
    Lively Member Feras's Avatar
    Join Date
    Sep 2000
    Location
    Homs, Syria
    Posts
    85
    marhaba VBOnliner...

    I had the same problem and I could not find the answer.
    I posted alot of messages about but still failed to have a solution.
    At last when I despair of that I shoosed to use the Microsoft ADO Data Control 6.0.
    Yesterday is history ... Tomorrow is mistry .. Today is a gift.

    VB6 , intermidiat

  3. #3
    Addicted Member
    Join Date
    Aug 2000
    Location
    Adelaide - Australia
    Posts
    150
    You need to provide a reference to
    Microsoft DAO 3.51 Object Library

    Use this code:
    Code:
    Dim db As Database
    Dim rs As Recordset
    Set db = DAO.OpenDatabase(App.Path & "\Data.mdb", False, False, ";Pwd=password")
    Set rs = db.OpenRecordset("SELECT * FROM table ORDER BY field")
    
    db.close

  4. #4
    Lively Member
    Join Date
    Oct 2000
    Location
    Singapore
    Posts
    98
    No sure if this works.

    rem Remember to choose Microsoft DAO compatibility library rem in the Project>Reference menu.

    Dim dbscustomers As Database

    Private Sub Command1_Click()
    Set dbscustomers = OpenDatabase("c:\windows\desktop\expenses1.mdb", False, False, pwd ="thepassword123")
    End sub

Posting Permissions

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



Click Here to Expand Forum to Full Width