Office SP3 Access 2003 - Form Close Failures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HTW_Man - 23 Oct 2007 14:56 GMT

Has anyone else seen this problem - occurs on many machines (20) after Office
2003 SP3 install yesterday - completely killed the application. (These are XP
machines).

Selected Forms open OK but on close get the MS screen of death - 'Access has
experienced a problem and needs to close- do you want to backup database,
repair it and restart Access' . Repairing does not fix anything. The only
common thread is all the forms have one or more drop downs.

Also occurs in selected reports where a drop down control was placed by the
Access Report designer.

These same forms/reports cannot be designed or imported / exported without
getting the close message.

I had to go back to a machine without SP3 and the app works fine - also OK
on 2002.

Anyone know of a fix?

Reply to this Message

Paul Shapiro - 23 Oct 2007 19:34 GMT

I was able to resolve Office 2003 SP3 problems with corrupt forms by
deleting the problem objects and importing them from an older version of the
mdb, which had never been opened in SP3. MS tech support also found that the
corruption could be removed by exporting the corrupt objects with
Application.SaveAsText and then importing the object from the text file with
Application.LoadFromText. In my case, once the objects were "clean" the
corruption does not seem to recur.
Paul Shapiro

> Has anyone else seen this problem - occurs on many machines (20) after
> Office
[quoted text clipped - 19 lines]
>
> Anyone know of a fix?

Reply to this Message