Results 1 to 4 of 4
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paaaword (Access 2000)

    See <post:=674,160>post 674,160</post:> and <post:=674,114>post 674,114</post:> for examples of how to open a password-protected database.

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password (Access 2000)

    How can i rewrite the following function include the password too :

    Public Sub KillObject(strDbName As String, acObjectType As Long, strObjectName As String)
    Dim strPassword As String
    strPassword = "pin"
    Dim db As DAO.Database
    Dim adb As Object
    Set adb = CreateObject("Access.Application")
    adb.OpenCurrentDatabase (strDbName)
    adb.DoCmd.DeleteObject acObjectType, strObjectName
    adb.CloseCurrentDatabase
    Set adb = Nothing
    End Sub

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password (Access 2000)

    Thank. The error point s to red in the following line :

    adb.OpenCurrentDatabase (strDbName , , , ";PWD=" & StrPassword)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Password (Access 2000)

    Please see the two posts I mentioned and read them.

Posting Permissions

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