469,323 Members | 1,601 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,323 developers. It's quick & easy.

Ms Access has stopped working?

101 100+
I have been working on my database and have added a new form and changed some other code. When I now enter the database and open the form in design view and try to look at my VBA code I get the error:-

MS Access has Stopped Working......etc and the application closes diwn.

I have saved copies of earlier versions prior to the new code and these work OK so I suspect it is to do with something I have added since. I have looked on the web and cannot get any sensible answer as to why it keeps crashing.

Does anyone have any answer to this please

I am using Set.Focus on my new form and am wondering if this might be the cause of the problem?
Oct 25 '11 #1

✓ answered by Cyd44

Hi NeoPa,

I suspected that this was an application problem rather than a database one so this is what I did which appears to have resolved my issue :

I went to Control Panel and chose Remove Program option. I then chose MS OFFICE and Change option which gave me an opportunity to Repair Office. This took about 30 mins but did not give me any clues about what it found or repaired. It Simply told me the Repair was complete!
Once I rebooted I was able to run Access with my database.

On another note, I read your recommended info on Mandatory Variable Declaration and I noted that many of my Class Modules did not contain Option Explicit, so I have entered this declaration into those.

The upshot is that my database is running OK (at the moment at least).

6 9827
NeoPa
32,173 Expert Mod 16PB
I would suggest starting by using the Bypass key (Shift) while opening the database. You may have a corruption, but we need info to start with. A full exact copy of the error message would be the next thing to post. If it gives a Debug option then select that and post the code it is stopped at along with the full error message.
Oct 25 '11 #2
Cyd44
101 100+
I am not sure what you mean by using Bypass key. I went to database and pressed Shift Enter but all I got was the MS error message Access has stopped working. I have tried the earlier versions and it is also happening with these now so the problem seems to have migrated
Oct 25 '11 #3
Cyd44
101 100+
Hi NeoPa,

I suspected that this was an application problem rather than a database one so this is what I did which appears to have resolved my issue :

I went to Control Panel and chose Remove Program option. I then chose MS OFFICE and Change option which gave me an opportunity to Repair Office. This took about 30 mins but did not give me any clues about what it found or repaired. It Simply told me the Repair was complete!
Once I rebooted I was able to run Access with my database.

On another note, I read your recommended info on Mandatory Variable Declaration and I noted that many of my Class Modules did not contain Option Explicit, so I have entered this declaration into those.

The upshot is that my database is running OK (at the moment at least).
Oct 25 '11 #4
NeoPa
32,173 Expert Mod 16PB
Cyd44:
I had suspected that this was an application problem rather than a dbase one so this is what I did which appears to have resolved my issue.
That was clever. I wouldn't have thought of that. Congratulations on finding your solution.

I'm going to edit that post for typos etc so you can go ahead and mark it as Best Answer (Unusual for posts by the OP but appropriate in this case I think).
Oct 25 '11 #5
Cyd44
101 100+
Thanks for the compliment. I thought I would put the resolution onto the forum just in case anyone else encountered a similar problem. I hope that is acceptable.
Oct 26 '11 #6
NeoPa
32,173 Expert Mod 16PB
Perfectly so. We encourage it in fact ;-)
Oct 26 '11 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Jeremy Holt | last post: by
29 posts views Thread by Patrick | last post: by
1 post views Thread by rickcasey | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.