Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2004
    Posts
    23

    Unanswered: Recover forms from Corrupted Database protected with VBA password

    I have a database protected with a VBA password. When I ran code that set the allowbypass to false, the code didn't complete and now the database will not open. It only wants to send bug report to Microsoft. When I try to import forms from the corrupted database, it tells me their is VBA Password and that I must open the VBA editor and supply password. Any suggestion on how I can to do this. I am able to import Queries and Tables, so I know that the database isn't completely ruined. Any suggestions would be appreciated.

    Jim

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Jim

    There is a rather clever guy that occaisionally contributes on this forum (WaynePhillips). Check his www - he specialises in db repairs

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Not this again ... OK. Here is a way to do this:

    1) Setup a DSN (system or otherwise) pointing to the offending DB
    2) Run the ODBC Repair - You will have to provide the correct password.
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Nov 2004
    Posts
    23

    Still unable to fix

    I've tried setting up a DNS and repairing the database. It's says that the database was repaired, but as soon as I go to open it, it crashes and want's to send an error message to microsoft. Is there anyway to get to the code without open the database so that I can remove Startup code?

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by dbjim
    I've tried setting up a DNS and repairing the database. It's says that the database was repaired, but as soon as I go to open it, it crashes and want's to send an error message to microsoft. Is there anyway to get to the code without open the database so that I can remove Startup code?
    Well ... Try doing the same thing again BUT DO NOT ATTEMPT TO ENTER THE DB ... Open a new, blank DB and import everything over from the repaired one ...
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Mar 2005
    Posts
    261
    Quote Originally Posted by dbjim
    I've tried setting up a DNS and repairing the database. It's says that the database was repaired, but as soon as I go to open it, it crashes and want's to send an error message to microsoft. Is there anyway to get to the code without open the database so that I can remove Startup code?
    I hope you tried the ODBC repair on a copy of the corrupt database ?! Otherwise you might've just made things much worse...

    ODBC repair doesn't fix Access specific stuff like VBA (unless its index related corruption, but sounds unlikely in this case).

    If you can't import everything into a new database, then you're more than likely going to need it repaired professionally.

    Pootle: Perhaps I need to pay you commission lol

    Wayne Phillips
    http://www.everythingaccess.com
    Last edited by waynephillips; 11-09-05 at 12:28.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by waynephillips
    Pootle: Perhaps I need to pay you commission lol
    Whaddaya mean perhaps?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Nov 2004
    Posts
    23
    Thanks for all the responses so far. I had backed up the database 3 hours before it crashed so I only lost 3 hours worth of changes. But I would like to learn how to resolve this problem in the future and possibly recover a couple of forms I changed to make sure I re-did them the same way. Is their any way to supply a password from VBA in another database using the transferdatabase method or getobject method or some other code?

    Thanks

    Jim

  9. #9
    Join Date
    Mar 2005
    Posts
    261
    Quote Originally Posted by dbjim
    Thanks for all the responses so far. I had backed up the database 3 hours before it crashed so I only lost 3 hours worth of changes. But I would like to learn how to resolve this problem in the future and possibly recover a couple of forms I changed to make sure I re-did them the same way. Is their any way to supply a password from VBA in another database using the transferdatabase method or getobject method or some other code?

    Thanks

    Jim
    At the moment you're trying various ways to get the objects back but it's quite possible that they are corrupt beyond repair. Save yourself some time and actually see if the objects are repairable at all first by getting a free recovery report here:

    http://www.everythingaccess.com/acce...baserepair.htm

    That way you know whether you are wasting your time or not.

  10. #10
    Join Date
    Oct 2003
    Posts
    311
    how do you run odbc repair?

  11. #11
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by mikezcg
    how do you run odbc repair?
    See my post above ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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