Link to home
Start Free TrialLog in
Avatar of jrogersok
jrogersok

asked on

Access 2010 Crashing

I have a new Access 2010 database I created today that has started crashing inconsistently.  I have a form that opens on start up and all of sudden it stopped working when loading.   I was able to open the database using the Shift-double-click technique to get to the main database window.  I can open the forms but some other forms now crash.  I've tried compacting and repairing and it crashes too.

I'll attach the file with the startup form displaying.  This is a test database so you can enter 99999 as the Stakeholder ID when the form displays which will then display several buttons to open various forms.  A pretty simple database with a small amount of macros and vba code.  Now I can't access any of the VBA code either; it comes up with the message "File Not Found" or crashes.

I have been creating databases with Access for 20 years and needless to say, this is very FRUSTRATING!   Will it ever be possible for Microsoft to come out with a program without a zillion bugs?????

I am running Office 2010, SP1 on a windows 7 machine.

Thanks!   Crashing-DB.accdb Crashing-DB.accdb
Avatar of remixedcat
remixedcat
Flag of United States of America image

have you tried to see if the file is corrupted or can be opened in other system/access version?

have you tried:
 http://office.microsoft.com/en-us/access-help/compact-and-repair-an-access-file-HP005187449.aspx

or this:

http://support.microsoft.com/kb/283849

or any of the other repair options?

if that doesn't work then you will need to disable DEP:

Your system might think the file is malicious and DEP is preventing it from working just in case.


Disable Data execution prevention for Access by:
computer>right click>properties>advances system settings>advanced tab>performance button>data Execution Prevention tab>Browse to access's .exe file>ok to close all dialogs
Avatar of als315
It is working in Access 2010. I've found only one possible problem:
You have not described variable StakeholderID and have no Option explicit.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jrogersok
jrogersok

ASKER

Thanks!  It was a corrupted system.  I was able to run it ok on my son's Mac with a virtual Windows box.

Thanks for everyone's suggestions