Repair corrupted forms

[Cliff top]

I have a database front end full of forms for data entry etc (stock control)
which links to a backend on a server. I have several basic macro's for
navigation. Theres just a small amount of VBA code for some operations I
can't get a macro to do.

It was designed and constructed in Access 2000. But due to continued
development has somehow got corrupted slightly. It will no longer open with
Access 2000... however having tried Access 2002 it opens ok. I've tried
compact/repair etc and the operation reports no problems and says completed.
If I save as Access97, then I can open in Access 2000 after converting
again, but there are anomalies- like cascading delete doesn't work with the
invoice detaillink table.

The question is: Is there a better repair program or a way to go through a
front end form etc to work out where the corruption is?

If it is just one form I can rebuild it, but rebuilding the whole thing
from the ground up would be a pain. I already did that some years ago when
the Access 95 frontend was upgraded to Access 2000. ps The current Acc 2000
has run fine for some years.

cheers Andrew

 

[Allen Browne]

Andrew, I assume you have both Access 2000 and 2002 available to you, so try
this sequence:

1. Using Access 2002, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file at this point.

4. Now using Access 2000, decompile the database by entering something like
this at the command prompt while Access is not running. It is all one line,
and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

5. Open Access 2000 (holding down the Shift key if you have any startup
code), and compact again.

6. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

7. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access 2000 to
rebuild the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

 

[Cliff top]

Wow, thanks

It may take some time to have a go at this, but I'll work through and report
back

Cheers
Andrew