Consulting

Results 1 to 2 of 2

Thread: Open protected Access database file in Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    2
    Location

    Open protected Access database file in Excel

    Hi everyone:


    I'm trying to open a protected Access database file. I have an MDB file, also MDW file and USER NAME and PASSWORD.

    Is it possible at all?

    So far I came up with this, but where do you put user name and password?
    [vba]
    Set oApp = CreateObject("Access.Application")
    oApp.SetDefaultWorkgroupFile "workgroup_file.mdw"
    oApp.OpenCurrentDatabase "database_file.mdb"
    [/vba]
    Last edited by dc2000; 03-04-2008 at 11:30 PM.

Posting Permissions

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