I had a very large number of query statements that I had converted to
SQL a long time ago aticipating that I would some day upsize my
application. Every now and then when I do an import to a new
application, some of the forms will import corrupted, and crashing the
whole application, though it works fine in the old application.
Today I did some experimenting on the two most recent corrupt form
files. I discovered that even when I duplicate only the SQL code
statements in the new forms "Record Source" (no fields, or anything
in design view), it still crashes.
If nothing has been placed in design view of these forms, and only the
SQL statements place in, "Record Source"; what else can it be but the
SQL statement?
What is in these two statements in these forms that that causes both
the application and MS Access 2003, on an XProSP2 machime with a
Pentium IV and 1gig memory, to crash upon import or merely opening
them directly into design view.
Example Form1:
SELECT DISTINCTROW Registration.Ev entID, Registration.At tendeeID,
[AttendeeLastNam e] & ", " & [AttendeeFirstNa me] AS [Attendee Name],
Attendees.Compa nyName, Registration.Re gistrationFee, [Sum Of Payments
Query].[Total Payments]
FROM Attendees INNER JOIN (Registration LEFT JOIN [Sum Of Payments
Query] ON Registration.Re gistrationID = [Sum Of Payments
Query].RegistrationID ) ON Attendees.Atten deeID =
Registration.At tendeeID
ORDER BY [AttendeeLastNam e] & ", " & [AttendeeFirstNa me];
Example Form2:
SELECT DISTINCTROW Registration.Re gistrationID,
Registration.Re gistrationFee, Events.EventNam e,
Registration.ev entdate, Events.StartDat e, Registration.Sa lesTaxRate,
[Sum Of Payments Query].[Total Payments], Registration.At tendeeID,
Registration.pr ogname, Registration.se rviceclass,
Registration.Re gistrationDate
FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query]
ON Registration.Re gistrationID = [Sum Of Payments
Query].RegistrationID ) ON Events.EventID = Registration.Ev entID
ORDER BY Registration.Re gistrationID;
John Phelan