Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2007
    Posts
    6

    Unanswered: how do i secure my Access DB?

    hello! i'm trying to add a password to my database, which is access. but when password is already set and trying to test the connection, i got a message that "....database cant be access. because it is open exclusively". I use the wizard in connecting a db.

    VB 6.0
    MS Access
    adodc control
    OLEDB 4.0

    please help me. thank you!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    This should really be posted in the Access Topic...

    Is there an Access locking file (*.ldb)?
    If so, and you're sure there is no-one in the database then delete this file.
    Alternatively move a copy of the *.mdb to another location and try connect to that version.
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2007
    Posts
    6
    sorry to be a noob in the forum. i'll just ask in access topic.

    yes sir. there a *.ldb file when i open my db. but when i close my db, the *.lbd file is also gone. i cant delete the *.lbd file while my db is open.

  4. #4
    Join Date
    Aug 2007
    Posts
    6
    what should i do to my VB for me to connect my Application to my DB with a password.

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    are you discussing VBA (Visual Basic for Applications, run from within Access, Excel, or other applications) or standalone Visual Basic?
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  6. #6
    Join Date
    Aug 2007
    Posts
    6
    yes sir. im using vb for application and use access as my db.

Posting Permissions

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