Delete any form field & when form is opened Access fails

[The_bald_head]

Hi,

I wasn't bald before I started this "minor" change.

A week ago I added a Memo field to a form, no problems with that.
This week I tried deleting the same field, which I did, but when I opened
the form Access promptly displayed it "has encountered a problem and needs to
close"

I did not think it was too much of a problem until:
1. it did this if I attempted to delete any field on any form.
2. it still happened on every form after I had restored the original form.
3. it still happened on every form on every backup that I have.
4. The pop up error box does not send the error report when requested.
5. All the above kept on happening even after power off / on, after every
rebuild / compact & repair / detect & repair / etc.........

The Error Signature I am getting is:
AppName: msaccess.exe AppVer: 11.0.8204.0 AppStamp:4763166b
ModName: mso.dll ModVer: 11.0.8221.0 ModStamp:483c699a
fDebug: 0 Offset: 0001f652


I am running Access 2003 (11.8204.8221) SP3 running on Window XP
Professional version 2002 SP3

As far as I am aware there has been no changes to any System or Application
on my pc.

Please let me know if you need any further information, any help will be
gratefully received.

 

[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.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

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

 

[The_bald_head]

--
The_bald_head

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

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi,

Thanks very much for your prompt reply.

I had to go back 5 weeks generations of backup before I found a version that
I could rebuild to a workable state and make the changes necessary - this
does not explain how I could have made the changes last week without problems
- and the fact that all the previous versions could be started, viewed and
the data updated.

The most interesting link you sent was about the Jet engine and that
different versions can cause problems - this appears to be the likeliest
candidate as the database is accessed by a small number of people scattered
around the globe, all of whom have different IT support and processes. I have
sent the http://windowsupdate.microsoft.com link to all my users so that they
can ensure they have the latest service pack with the latest jet engine
software.

Again, thanks for your help