Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2009
    Posts
    3

    Unanswered: Problem logging into Access db

    The developer who orginally developed this db for us has since "left" the company. I have his login and password but when I try and open the db, a message box appears saying I don't have permission to run......

    When i hold down "Shift" to bypass the autoexec, the db opens and I can see the tables, queries, etc. but if i try and do anything it says i don't have permission.

    How can I login as this person to get admin rights?!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make sure you are using the right .MDW file?

    You might want to try changing permissions on the objects too, but for heaven's sake, take a backup first!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Oct 2009
    Posts
    3

    Locked VBA project

    I'm able to log into a db developed by another co-worker (who's since left the company) using his login info...however, because it's an ACCESS project - when I try to click on a module it brings up the VBA code behind page and prompts me for another password which I can't get into...i've tried every possible solution and can't get in....is there a way to bypass/hack into this?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Never tried it... but I have to ask is the person who left able to be asked for this password?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Oct 2009
    Posts
    3
    unfortunately that's not possible - there are VBA password crackers out there but I just can't find where the file is saved....if it's part of an .adp file is the VBA code stored in a separate file?

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Yes. Try using the attached tool on the mdw file (ie. run the mda file in the attachment and then browse to your mdw file.) It will then show you everyone's user name and their password. Then just write down a user name/password who has admin type permissions and use that to log in and enhance your permissions (or when prompted.)

    There should be a 2000 (Msa2Kpt.mda) and 97 (Msa97pt.mda) version. The 2000 should works with XP.

    Let me know if it helps.

    When testing the mdb, make sure you still use your shortcut which contains the mdw file parameter so it knows what permissions to apply after you enter the user name.
    Attached Files Attached Files
    Last edited by pkstormy; 10-11-09 at 05:28.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    That's good for reading MDW files, but VBA Project code passwords might be a completely different thing. Every time I have used one of those, I made sure I meticulously documented it so that this kind of thing wouldn't happen.

    I'd like to know what happens here too, so when you get it cracked, please let us know how you did it!

    there are VBA password crackers out there but I just can't find where the file is saved....if it's part of an .adp file is the VBA code stored in a separate file?
    The file is your MDB file that contains the code.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I never created MSAccess security (ie. an mdw file) on an ADP. Didn't think you actually could.

    If it's an ADP, I'm guessing the password would then stem from the backend data SQL Server (or mysql, etc.)

    I'm confused on this: "there are VBA password crackers out there but I just can't find where the file is saved....if it's part of an .adp file is the VBA code stored in a separate file?"

    Is it an ADE, ADP, MDB with MDW, Visual Basic or what?

    If you're looking for something that will crack compiled code such as an ADE or MDE, good luck. They're never 100% and you'll end up doing a fair amount of coding even after it's been 'professionally' cracked. Modules can often be recovered but code inside a form/report is usually not recovable using any crack method.

    Also, did the login your using get removed from the network system so MSAccess cannot recognize it? If so, re-create the login on the network.
    Last edited by pkstormy; 10-12-09 at 23:06.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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