Form or macro corrupted?

[KateB]

A colleague has a database created by someone who has since left the company.

They access it by a form which is opened by a macro. We get the message
Action failed (with only a halt option) which says Macro_name: Ipt_incidents,
Condition: True, Action Name: OpenForm, Arguements:
Ipt_incident,Form,,,,Normal. I've tried going directly to the form but it
won't allow me to open it (all other forms are OK). It literally does
nothing when I try - no error, nothing!

I assume the macro is corrupted and overrides the opening of the form
directly - is there an easy way to repair it, or should it be deleted?
They're loathe to let me try anything without further advice!

Can anyone help? Many thanks

 

[Arvin Meyer [MVP]]

First, always work on a COPY of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[KateB]

Many thanks for your suggestions - I'll pass them on. We always have a
problem making copies of DBs because they're big files and IT limit our save
quota, but the server backs up each night so might use that option.