Access quitting unexpectedly

[trandel]

Hi

Am using Access 2000 and Windows XP SP2

I am experiencing a problem with Access simply quitting without any error message or any other indication. It is intermittent and occurs at random points in the application usually when opening a form or navigating between records within a form.

I suspected a corrupt DB and have done the following:

1. Compact and Repair
2. Created a new DB and imported the old DB files
3. Decompiled
4. Used an Access DB recovery service

Despite the above I still experience these random incidents.

Any ideas very welcome

Regards

Tony Randell

 

[Dennisk]

is it a fe/be with the be on a network?

 

[trandel]

At this stage it is a complete db but it will eventually run on a network as a fe/be

 

[MicroE]

Split the db and give each user their own copy of the FE.
http://www.myaccesstips.com/deploy/deploy.html

 

[trandel]

I am still developing so dont really need to split for one user - me.

But I did anyway and it still gives the same problem.

 

[Rich]

A2000 was the most bug ridden bit of software ever released by Microsoft, do you have all the patches?

 

[trandel]

Every MS product is up to date but I have checked Office Update this am to make sure - and all is OK.

I am frustrated as this is an update to an existing application which is working just fine. I must have done something during the updating to 'break' it.

 

[unclejoe]

Hi Tony,

Sometimes it is cause by AutoCorrect, missing name queries, missing tables and host of others.

You might want to look at allenbrowne site.
Link
Link
snip

Hi
Am using Access 2000 and Windows XP SP2
Tony Randell

 

[MicroE]

From the VBA Editor open the Reference window (Tools > References from the menubar).
- Remove one of the checked references
- Decompile the application - http://www.fmsinc.com/free/newtips/access/accesstip7.asp
- Recheck the reference ONLY if it is needed to compile.

Repeat these steps for every reference checked. This will eliminate references the application is not using. I find the Office Web Components reference sometimes appears in the list and causes issue.

 

[trandel]

I have done:

Checked all the References - all justified
Decompiled
Compact and Repair
Recompiled

Worked for a short time ( with me hooting with glee) and then failed again - Access just quits!

It must be something I have done during this update.

I have thought of another way to process my changes and will try that.

This will avoid using an existing form (although it is hidden) that is used to update normal orders. The new change is a simple update not requiring the full complexity used in the normal order form. So I plan to update by simply adding a new record to the orders table directly.

Thanks to all for your suggestions.

 

[trandel]

Solved!

I have upgraded to Office 2003 and all the problems have gone away!!

Office 2000 must have been corrupted in some way ...........

Now I can get on with the project.

Thanks again for all your suggestions