Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • Last Modified:

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
0
CRB1609
Asked:
CRB1609
4 Solutions
 
Anders Ebro (Microsoft MVP)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 FyeCommented:
concur with Anders, but first, create a backup of your database.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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
 
Helen FeddemaCommented:
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
 
CRB1609Author Commented:
Thank you all, very much.

Clive
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now