How can I rebuild my application to remove any corruptions.

I think my application database is corrupted.  How do I to rebuild the database to remove the corruptions, regardless of where they may be?

Thanks in advance.

Clive
Clive BeatonAccess DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
You should also Compact and Compile your application. I suggest this process:

1. Compact the database
2. Compile it - from the VBA menu select Debug - Compile. Correct any errors and continue doing that until the Compile menuitem is disabled.
3. Compact again

Now run the Decompile as Anders suggests

Also be sure your Office and Windows installs are fully up to date.
0
 
Anders Ebro (Microsoft MVP)Connect With a Mentor Microsoft DeveloperCommented:
As a first step, I can recommend doing a Decompile  .

In my experience this has solved 98% of any issues I've had. There has been very rare occasions where the only fix I could get was to create a new database, and import the objects into that new database.
0
 
Dale FyeConnect With a Mentor Commented:
concur with Anders, but first, create a backup of your database.
0
 
Helen FeddemaConnect With a Mentor Commented:
Make a brand-new database, and import all objects into it from the problem databasse.  If there are any problem objects, leave them behind and recreate them in the new database.
0
 
Clive BeatonAccess DeveloperAuthor Commented:
Thank you all, very much.

Clive
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.