Access crashing on a form

[rgmw]

An mdb file/database that I inherieted crashes on one particular form
sometimes. I've been able to determine:

- If the user uses it in Access 2003, when adding a via form, Access
crashes (w/the msg, Sorry for the inconvenience, with a checkbox
prompting to Restart Access.
- If the same user uses it in Access 2007, there's no problem.
- The PC that the mdb was created on has Office 2003 works (I think
the database was created in Access 2002, but I'm not sure.)
- I've went into VBA Editor > Tools > references and verified that the
same Controls are on both PC's, for 2003. (There are NO "missing"
items checked - all controls/references appear to be there.)

What else can I check? Ugh!

 

[David-W-Fenton]

m:

An mdb file/database that I inherieted crashes on one particular
form sometimes. I've been able to determine:

- If the user uses it in Access 2003, when adding a via form,
Access crashes (w/the msg, Sorry for the inconvenience, with a
checkbox prompting to Restart Access.
- If the same user uses it in Access 2007, there's no problem.
- The PC that the mdb was created on has Office 2003 works (I
think the database was created in Access 2002, but I'm not sure.)
- I've went into VBA Editor > Tools > references and verified that
the same Controls are on both PC's, for 2003. (There are NO
"missing" items checked - all controls/references appear to be
there.)

What else can I check? Ugh!

You should probably run a decompile process, but from your
description, my gut reaction is that it's more likely a data-based
error. That is, there's something about the data in particular
records that the database engine doesn't like (that kind of thing
shouldn't happen, but it does).

I assume you've done a compact on the front end, which would discard
the compiled query plan for the form. If you haven't, you definitely
should.