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

Wy do these 2 SQL statements corrupt both form and crash my Appl.?

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;
*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!
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.