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!

rgmw <(E-Mail Removed)> wrote in
news:f28728c5-1014-4af4-98d3-(E-Mail Removed)
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.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/