Microsoft Access has stopped working - with Split Form with Sub Form

Question

Using Windows Enterprise 7 - 64 bit

This issue is consistent across all my PCs, and appears to be regardless of OS or anything else.

Using Microsoft Access 2010.  

Have a DB with a several forms that open up as tabs.  One of them is a SPLIT FORM that is causing the crash consistently.  The main form has a subform on it and i think this might be the problem but can not verify that.   The form opens fine and operates fine, and I can go to and from design views but when i try to Close All or exit the whole program, it bombs EVERY time.

Anyone have any idea?

Thanks!

Answer 1

I also have a sub form on main form with split form view and no problem about you mentioned.

you can send your file to me with your convenience.

Answer 2

Tom, thanks again for your help.  I created a copy of the db for testing and followed these instructions:

The Microsoft Access /decompile command

Fortunately, Microsoft Access offers a way to fix the VBA compiled state with the /decompile command line option. The Compact and Repair feature only applies to the tables and does not impact VBA code. The decompile command does.

When Access is started with this and you open your database, it discards all the old VBA compilations, and leaves just your VBA source code. You'll need to compile again to get the compiled state. After compacting, your database may be significantly smaller.

To decompile your database, follow these steps

1. From the Windows, Start, Run command line, type: msaccess.exe /decompile

where msaccess.exe includes the complete path. For example, for Access 2013:

C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE /decompile 2. From Access open the database you want to decompile (with trusted authority for Access 2003 or later) 3. Open up any module. Compile it via Debug, Compile.., then File, Save. 4. Go back to the database and Compact it. The location of the Compact command varies by Access version.

The database size should be reduced and the strange errors related to the VBA code should be gone.

The example above is for Microsoft Access 2013, but it also applies to Microsoft Access 2010, 2007. 2003, 2002, 2000, 97 and earlier.

On number 3) above, when i went Debug, Compile,  i got an error on every line of code.

Am I following the wrong instructions?

Thanks again.

ps.  i did extensive testing on my DB and am quite sure that the split form is what is causing the Access 2010 crash.  I can send the file if you think that would be beneficial.

Answer 3

I am open to that, but first search the web for "Access Decompile" and follow those instructions. I'm somewhat optimistic it will fix your problem.

Answer 4

Using Windows Enterprise 7 - 64 bit

This issue is consistent across all my PCs, and appears to be regardless of OS or anything else.

Using Microsoft Access 2010.  

Have a DB with a several forms that open up as tabs.  One of them is a SPLIT FORM that is causing the crash consistently.  The main form has a subform on it and i think this might be the problem but can not verify that.   The form opens fine and operates fine, and I can go to and from design views but when i try to Close All or exit the whole program, it bombs EVERY time.

Anyone have any idea?

Thanks!

Tom, Im afraid I have no idea how to do that.  It appears to be a problem with Access itself.  Hard to believe.  I suppose it could be some code in my file, but all the symptoms point towards Access just cant handle Split Forms that have a subform on them.   Anything further?

Can I send you the file to have you see if there is anything obvious that I am missing or doing wrong?

Thanks!  jm

Answer 5

Have you tried to decompile the application?