Rather a long saga.
I recently converted an Access 97 db to 2003. The FE links in tables
from db1 & db2. All was working fine. Then, out of the blue (about an
hour before I was due to give a demo), I opened the FE and it crashed.
All the usual things - decompile, importing, etc, did not help. I
retrieved a backup from a few days back and, to my surprise, the same
thing happened. Took a backup from a month ago and - same thing.
So it wasn't the FE. Must be the data. I took two '97 version copies
of db1 & db2, converted them - still crashed. (Same thing happens on a
second PC.)
The crash *seems* to be caused by any combo control. When its rowsource
is a *saved query* which is a join between two certain tables, then it
crashes. When I paste the same sql statement directly into the
rowsource, it doesn't cause any problems.
In a test database, I recreated the two tables (copying & pasting the
fields wasn't good enough) and that seemed to fix the problem. However
my db has about 50 tables and I'd rather not have to re-create them all.
When I try importing the objects from my original 97 database into a new
2003 database, it crashed as well. If I delete the linked tables first
and then try to import, it succeeds.
In short, I'm rather stuck. There seems to be some data-related
problem. I do finally have a working version, but there is a problem
somewhere and I don't want this happening once again.
Does anyone have any suggestions?
--
Zippy S
