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
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
It is working in Access 2010. I've found only one possible problem:
You have not described variable StakeholderID and have no Option explicit.
You have not described variable StakeholderID and have no Option explicit.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Thanks for everyone's suggestions
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