I have a few cases where I created access2000 databases with access 2002
(xp).
And, the end results of the database did have some trouble.
I simply re-installed access 2002, and have not since seen this problem.
So, if your accessXP disk, or install somehow did not work 100%, then that
could very well be the source of your troubles.
I would clean the accessXP disk, and re-install....and further make sure all
the updates to office are installed (don't run any un-patched version..or
any early pre-release version).
I have no idea as to why I had these problems..but they are much like
yours...after loading,a and testing on a a2000 box, simply modify, or
changing the control seemed to fix the problems.
However, I did have to re-install everything on my development pc, and when
I re-installed access 2002, then I never saw the problem again. (so, my
guess is that some corrupting, or some bad installed occurred with the
office 2002. And, for some reason, it would result in a bad a2002 mdb. You
see, I was development on my pc, but did NOT have a2000. I would then use
another pc to create the mde..and that mdb, and mde did have troubles (so,
the only thing could come up with was that my a2002 install was not 100%)).
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn