J
John Phelan
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 files. And I
discovered that 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.EventID, Registration.AttendeeID,
[AttendeeLastName] & ", " & [AttendeeFirstName] AS [Attendee Name],
Attendees.CompanyName, Registration.RegistrationFee, [Sum Of Payments
Query].[Total Payments]
FROM Attendees INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON
Registration.RegistrationID = [Sum Of Payments Query].RegistrationID) ON
Attendees.AttendeeID = Registration.AttendeeID
ORDER BY [AttendeeLastName] & ", " & [AttendeeFirstName];
Example Form2:
SELECT DISTINCTROW Registration.RegistrationID,
Registration.RegistrationFee, Events.EventName, Registration.eventdate,
Events.StartDate, Registration.SalesTaxRate, [Sum Of Payments Query].[Total
Payments], Registration.AttendeeID, Registration.progname,
Registration.serviceclass, Registration.RegistrationDate
FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON
Registration.RegistrationID = [Sum Of Payments Query].RegistrationID) ON
Events.EventID = Registration.EventID
ORDER BY Registration.RegistrationID;
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 files. And I
discovered that 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.EventID, Registration.AttendeeID,
[AttendeeLastName] & ", " & [AttendeeFirstName] AS [Attendee Name],
Attendees.CompanyName, Registration.RegistrationFee, [Sum Of Payments
Query].[Total Payments]
FROM Attendees INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON
Registration.RegistrationID = [Sum Of Payments Query].RegistrationID) ON
Attendees.AttendeeID = Registration.AttendeeID
ORDER BY [AttendeeLastName] & ", " & [AttendeeFirstName];
Example Form2:
SELECT DISTINCTROW Registration.RegistrationID,
Registration.RegistrationFee, Events.EventName, Registration.eventdate,
Events.StartDate, Registration.SalesTaxRate, [Sum Of Payments Query].[Total
Payments], Registration.AttendeeID, Registration.progname,
Registration.serviceclass, Registration.RegistrationDate
FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON
Registration.RegistrationID = [Sum Of Payments Query].RegistrationID) ON
Events.EventID = Registration.EventID
ORDER BY Registration.RegistrationID;