A2002 crashing

[mark curtis]

Dear all,

I am using a converted 97 db in a2002,

I have a main form called frmDocumentRegister with a tab control on with many sub forms. I have placed the following code in one of the controls and the db keeps crashing after update:

Private Sub ApprovedBudget_AfterUpdate()
Me.listbox206.Requery
Forms!frmDocumentRegister.Refresh
End Sub

I think the refresh is the problem but the code works fine in a97.

I have the doa ref higher priority that ado?

Any help please

 

[mission2java_78]

Rather than refreshing the form try requerying it.

Jon

 

[pono1]

Adding to Jon's post: Do you have any other controls in your form that use a formula of some sort, referencing other controls? If so, you may want to remove them and see if the app still crashes.

Regards,
Tim

 

[Pat Hartman]

Define crash. Access abends? Do you get a message? Does it offer to call Microsoft and report the error? Try repairing the db. Try creating a new db and importing all objects.

 

[samiuweb]

same problem

this problem started today

access stops working and it offers to call Microsoft and report the error. it only happens when loading one specific form....i tried doing what pat suggested, started a new db and imported everything, but it crashed and asked to call Microsoft again while importing.

Should i update Office or smth?

The db is on a network and i tried to open it from another system in the network, and there it says "not enough memory" on the same form (other forms work fine).

any help much appreciated.

pm

 

[samiuweb]

i forgot to mention that during import access stops while importing the same table where the form was based on (tblProject, frmProject)

 

[Pat Hartman]

Sounds like you've identified the corupted items. Import everything else except them. Then rebuild the corrupted items. I presume you first tried to repair the db. Sometimes repair will fix the problem.