Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Dec 2015
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error 35012 in Access 2013

    I have an Unexpected Error 35012 when I try and open a VBA module in ‪Access 2013. I've tried with these steps that i saw in this forum:

    1. Create a new Microsoft Access database.
    2. On the File menu, point to Get External Data, and then click Import. Import
    all database objects (tables, queries, forms, reports, macros, and modules)
    into the new database.
    3. If you receive the "Unexpected error 35012" error message when you import a
    specific database object, repeat step 2, but exclude that object and restore
    the damaged object from a good backup.<hr>

    Obviously, it not work for me.
    How can I repair it?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    That generally means you have a corrupted VBA project or a corrupted form. To test that, import objects in steps to see where you get the error. Do the tables and queries first. Then try importing forms. Chances are one of the forms will be the issue, but if they import successfully, do the reports. Then finally do the VBA project. If that is corrupt, you can try the /decompile option to take the code out to text file - you will need to do a search on how to do that. It may or may not solve the problem. I've seen reports from a number of people who finally resorted to rebuilding their database.

    A couple of things to look at - what format is the database - .mdb or .accdb? Also is the database split into a front-end and back-end? Sharing front-ends is one of the primary causes of corruption in Access databases.
    Wendell

  3. #3
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Quote Originally Posted by Matt485 View Post
    I have an Unexpected Error 35012 when I try and open a VBA module in ‪Access 2013. I've tried with these steps that i saw in this forum:

    1. Create a new Microsoft Access database.
    2. On the File menu, point to Get External Data, and then click Import. Import
    all database objects (tables, queries, forms, reports, macros, and modules)
    into the new database.
    3. If you receive the "Unexpected error 35012" error message when you import a
    specific database object, repeat step 2, but exclude that object and restore
    the damaged object from a good backup.<hr>

    Obviously, it not work for me.
    How can I repair it?
    Before you don anything else make a backup!

    You have a corrupted object. In most cases you will have to restore the object.

    Before attempting to repair:
    Make sure that the database in on the local hard drive (not, not a network share or USB drive.
    You will need to restore the corrupted object from one of your daily a back ups.

    I usually import all the working (not corrupted) objects into a new back database. Then import the objects that were are corrupted from a backup up copy when the objects were working.

    Hopefully this is a split database. If not, this is a great time to split it to help prevent this from happening again.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  4. #4
    New Lounger
    Join Date
    Dec 2015
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi guys, thanks for your replies.

    I still can not solve the problem. I tried everything that you say, but I can not repair the database.
    - The database is .mdb.
    - This is not a split database and yes is a great time to split it..

    A friend says to the best option is a recovery tool, i don't know. What is your opinion? The data are important and I do not want to waste more time on it, so if the solution is pay, i don't care.

  5. #5
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Are you saying that restoring the corrupted object from a working backup copy did not fix it?
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Matt,

    I had a similar problem about a year ago (a corrupted form) and I had to export every object in the DB (luckily it was already split so the data was ok) then import all BUT the corrupted form into a new DB then MANUALLY recreated the busted form. I had saved the code behind the form separately so it was easy to replace once I recreated the form.

    See this page for instructions.

    One thing you might try before going to those lengths is the VBA Decompiler. Note: if you are using WOT or similar link scanning system, it reports that the site has a poor reputation so be warned, personally I've never had a problem with it...YMMV!

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    New Lounger
    Join Date
    Dec 2015
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi RetiredGeek, thanks for your reply.
    I tried with the VBA Decompiler but unfortunately it does not work.
    I'm starting to lose hope. I've read some articles about the best access recovery tool, but I honestly do not know what is the best. Guess I should test some programs and see what happens.
    I will keep you informed. Thanks for the help anyway.

  8. #8
    jwoods
    Guest
    One thing that sometimes works for corrupt Excel spreadsheets that may work for corrupt Access DB's is to open the file using LibreOffice...

    For Excel it's LibreOffice Calc, and for Access it's LibreOffice Base.

    Not much to lose by trying it...

    https://www.libreoffice.org/download/libreoffice-fresh/

    Note: If you decide to try it, do not change the defaults of your Office files to use LibreOffice during the install.

  9. #9
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Matt,

    Did you look at the instructions in the first link "See this page for instructions" ?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  10. #10
    New Lounger
    Join Date
    Dec 2015
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just want to say that I was able to solve my issue and I'm so happy.
    RetiredGeek and jwoods, I had already tried those options, and none worked.
    Anyway thank you all for the support.

  11. #11
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Matt,

    Glad to hear you have it sorted. Care to share what you did for the benefit of others?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  12. #12
    New Lounger
    Join Date
    Dec 2015
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sure Retired Geek, sorry. I used this software http://www.cimaware.com and It worked excellent, I'm really surprised, but glad.
    Thanks for all one more time.

    Quote Originally Posted by RetiredGeek View Post
    Matt,

    Glad to hear you have it sorted. Care to share what you did for the benefit of others?

Tags for this Thread

Posting Permissions

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