Corrupted database!!

[ramab]

Hi,
Each time im trying to access a particular form, my application crashes and gives me "Microsoft access needs to close.....sorry for the inconvenience". I have try all ways to repair my database but i still get the error. Im using access 2007. The thing is that, when i open up my Microsoft visual basic code and when i access my application, it doesnt crash!!!!it saves the form correctly. And if i closes the visual basic code, and i try to open the form again, it doesnt crash.

But if i close access completely and try to open the form again it crashes. And again if i open my code, it doesnt crash.

Plz help.

Thanks in advanced.

[puppydogbuddy]

Try the recovery steps on the following links...read both links first before doing anything:

http://allenbrowne.com/recover.html

http://allenbrowne.com/ser-47.html

[missinglinq]

Your duplicate posting of this question/problem has been deleted! Please refrain from this prohibited behavior in the future.

From FAQs

Do Not Double Post Your Questions

Double posting is where you start a thread on a topic and then for some reason start another thread on exactly the same topic in the same forum. Please do not do this because

• It makes it very hard for people to answer you especially if there are answers happening in all the threads you have started because they have to read 2 or more threads in order to see what has already been said.
• It swamps the forum with your problem resulting in less attention for the other threads.

If you feel for some reason that you post has been overlooked (for instance it hasn't had any replies) please do not repost the question. Post a message to the thread you started, this will bump it back to the top of the thread list for the forum.

Thank you for your attention in this matter.

Linq ;0)>

[ramab]

Try the recovery steps on the following links...read both links first before doing anything:

http://allenbrowne.com/recover.html

http://allenbrowne.com/ser-47.html

Hi,
Ive try these steps, but i keep getting the same problem. But if i open my code then access my application,it doesnt crash. I'm really stuck..

[puppydogbuddy]

Hi,
Ive try these steps, but i keep getting the same problem. But if i open my code then access my application,it doesnt crash. I'm really stuck..

Well, if your forrm is not corrupt, maybe you have bad data in the table that form references. Go to the table, open it and see what happens. And if the record source of the form is a query, open the query by itself and see what happens.

Also, did you do the decompile/compile of your code that was suggested in the recovery procedures?

[Annalyzer]

What is the record source for your form? I was having a similar problem where I was trying to populate a combo box with a query that was pulling calculated fields. As soon as I took the calculated fields out of the query that was my record source, I quite getting the error.