Why is my Database Crashing ?

[testkitt2]

Hello all !

I have a database that works fine until you select ' records ' from the toolbar and then choose
' Refresh ' ... this causing the database to "Crash". I'm running WinXp with MS Office 2003.
After the crash I get an error stating the database will try to repair itself and recover from this error. The error message has a link to see what the error contains....
It gives me the following:



quote:
--------------------------------------------------------------------------------

AppName: msaccess.exe AppVer: 11.0.6355.0 AppStamp:40aa97a8
ModName: msjtes40.dll ModVer: 4.0.8618.0 ModStamp:403430ac
fDebug: 0 Offset: 00009065

--------------------------------------------------------------------------------



My feeling is this......
It has to be in the VB code, because all my other DB's work fine when refreshing from the toolbar menu.

If i remove all VB from this database it does not crash.

Can anyone tell me what is causing this behavior.
Any help is appreciated.

Thanks in advance....

Testkitt2

 

[Elysium]

Testkitt2,

Someone else had this same problem listed in the following thread:

Tek-Tip 900489

This person indicated that it had something to do with a filter on the recordset. willir had some good advice in there as well. Give it a read.

Randy

 

[mhcruella]

I had the same problem on one of my forms - especially on 2003. I had to change my VB code from a refresh to a requery and the database stopped crashing. I haven't had a problem since.

 

[kjv1611]

You could try just doing a find/replace (based on mbcruella's suggestion) {just make sure you create a backup copy of your database first, just in casein the vba window, and type in .Refresh in the find field, and .Requery in the replace with: field, and see if that is good enough of a fix - worht a try..

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[testkitt2]

Good evening to all...

In searching before posting I was unable to find the link that Elysium refers to below...

Elysium (Programmer) Sep 17, 2004
Testkitt2,

Someone else had this same problem listed in the following thread:

Tek-Tip 900489

After reading and trying several tips here and having no success with the my problem, I followed the link and read that post. I tried some of those suggestions too...but to no avail. Then I read the suggestion from the AceMan who says...

Rename the (problem) form, then copy and paste it back with the original name. If this does not help, then your form is corrupted.

I tried the rename,copy & paste procedure..but to no avail.
So I deleted the newly pasted form and then with the orginal form already renamed, I created a fresh form using the original table.
I saved it with the original form name. then I open both forms. the new form I selected every on the form and deleted it. then I selected all on the renamed form, copied and paste it to the new blank form. I then went into the VB editor, selected the code on the renamed form and paste it to the new form...and save it.

I ran the DB to see if it would crash again...clicking on access's default toolbar..selecting records...refresh..and it did not crash.... I think this did the trick.... Yes..Yes..Yes..

Thanks to all of you guys for your input...
and the AceMan.

Testkitt2

 

[willir]

Well give the guy a star.

But, also, you may want to apply any Office / Access updates...
Automatic Update Services (Download Centre)

Richard

 

[testkitt2]

Good evening....to all
All my office apps are fully updated...also already have
jet 4.0... thanks anyway.

question? Willir
I would like to give AceMan a star...but how can I do this if his comments were attached to a link...?
Tell me how and consider it done.

See ya.

Testkitt2

 

[willir]

Follow the link to the original post as above.
Sum of Row totals Find AceMan's post, and click on "Thank AceMan1 for this valuable post". You do not have to have submitted the question to reward the tipster with a star.

AceMan works real hard to help, and is very knowledgible. We are not paid to help -- we do it on our own, for various reasons. It amazes me that on a page of 40 posts, only 7 have stars. Does this mean that less than 20% of the posts have a successful answer. But that is just me rambling on...