By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

What is causing these 2 forms with SQL statements to corrupt when imported

P: n/a
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.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;
John Phelan
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.