Results 1 to 5 of 5
  1. #1
    sleake is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    51

    Many errors using database forms -- getting errors when try to decompile

    Built a database that all of a sudden was unusable; anything I clicked would crash Access. Created a new database (turned off AutoCorrect) and imported all objects. Yesterday I tried it and it was working perfectly. Today, everything I touch generates an error.

    I've been trying to decompile. Both DBs are .accdb. files. Access 2010 and Windows 7, also tried on XP. Same errors as below.



    Created the following command line: "c:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" \decompile and get the error "Can't find the database decompile.mdb"

    I've tried changing it to msaccess.exe \ decompile (space before decompile) ("option MS Access doesn't recognize")
    No quotes ("can't find c:\Program")

    This works to open Access, but of course not to decompile:
    c:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE

    Does anyone have a suggestion? I have decompiled successfully before -- but with an .mdb, not an accdb, and on XP, not Win7.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,077
    Learned something new - never heard of decompile.

    According to this should be possible with accdb: http://stackoverflow.com/questions/3...se-application
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    You should use the forward slash and a space in between. /decompile

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Don't know what steps you took in creating a New Database. If you copied and pasted or imported, you no doubt copied over the errors as well. Do you not have backups?
    Was the db perhaps split? I have seen fields in tables get corrupt as well as forms without affecting the rest of the db.
    Have you tried splitting the db if it is not already? Have you created new tables and tried importing the data?

  5. #5
    sleake is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    51
    Amrut: Re /decompile. What a dumb mistake -- and I have a document with decompile statements in it for other databases that are correct. Thanks for "opening" my eyes.

    burrina: This is a database that I'm in the process of building, but also using while doing so. As it happens, I loaded it on a computer with XP and the problems disappeared. Go figure. I've now put it back on Win7 machine, and it seems to be working.

    I created it by importing all objects -- it was not split.

    Even though it's working, I will take your advice and create new tables (the main one has only about 15 records) and import just the data. I had planned to split it anyway, so I'll do that first. I'm hoping the data entry form is not corrupted, as that's the piece that's taken a lot of time. So I'll try importing that, and hope for the best.

    Thanks to you both!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 10-07-2011, 10:58 AM
  2. Calculation Errors
    By billgyrotech in forum Database Design
    Replies: 10
    Last Post: 08-10-2011, 11:00 AM
  3. Evaluate Database Errors
    By billgyrotech in forum Access
    Replies: 2
    Last Post: 08-09-2011, 01:29 PM
  4. Replies: 10
    Last Post: 07-25-2011, 12:07 PM
  5. SQL that errors in VB
    By Wayne311 in forum Programming
    Replies: 3
    Last Post: 02-14-2011, 10:17 PM

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
  •  
Other Forums: Microsoft Office Forums - Senior Forums