VBA, Query Left Join Causes Access to crash only in Windows 2000

Query Left Join Causes Access to crash only in Windows 2000

Author	Message
Paul Saa #1 / 3	Query Left Join Causes Access to crash only in Windows 2000 A query with a left join was created and used successfully in NT without ant problem, but when used on a Windows 2000 machine the query causes access to crash. A: Converted the 2000 operating system to resemble an NT box B: Ran SFC Problem still persists, any suggestions. ========================== SELECT DISTINCTROW Customers.[Customer Name], Customer_Contacts.Contact, Customer_Contacts_Selected.templ_select, Customer_Contacts.E_mail FROM Customers INNER JOIN (Customer_Contacts LEFT JOIN Customer_Contacts_Selected ON Customer_Contacts.ID = Customer_Contacts_Selected.ID) ON Customers.Counter = Customer_Contacts.CustID WHERE (((Customers.[Customer Name]) Is Not Null) AND ((Customer_Contacts.Contact) Is Not Null) AND ((Customer_Contacts.E_mail) Is Not Null)) ORDER BY Customers.[Customer Name], Customer_Contacts.Contact;
Wed, 12 May 2004 11:12:17 GMT

Lynn Trap #2 / 3	Query Left Join Causes Access to crash only in Windows 2000 See my answer in microsoft.public.access.externaldata. In the future please do not multi-post. If you really need multiple lists to see your post then Crosspost (address the post to all the groups that you want to see it), but use that with discretion. -- Lynn Trapp MS Access MVP www.nwidevelopers.com Quote: > A query with a left join was created and used successfully in NT without ant > problem, but when used on a Windows 2000 machine the query causes access to > crash. > A: Converted the 2000 operating system to resemble an NT box > B: Ran SFC > Problem still persists, any suggestions. > ========================== > SELECT DISTINCTROW Customers.[Customer Name], Customer_Contacts.Contact, > Customer_Contacts_Selected.templ_select, Customer_Contacts.E_mail > FROM Customers INNER JOIN (Customer_Contacts LEFT JOIN > Customer_Contacts_Selected ON Customer_Contacts.ID = > Customer_Contacts_Selected.ID) ON Customers.Counter = > Customer_Contacts.CustID > WHERE (((Customers.[Customer Name]) Is Not Null) AND > ((Customer_Contacts.Contact) Is Not Null) AND ((Customer_Contacts.E_mail) Is > Not Null)) > ORDER BY Customers.[Customer Name], Customer_Contacts.Contact;
Thu, 13 May 2004 02:36:34 GMT

Paul Saa #3 / 3	Query Left Join Causes Access to crash only in Windows 2000 Thank you for your suggestion. Paul Quote: > See my answer in microsoft.public.access.externaldata. In the future please > do not multi-post. If you really need multiple lists to see your post then > Crosspost (address the post to all the groups that you want to see it), but > use that with discretion. > -- > Lynn Trapp > MS Access MVP > www.nwidevelopers.com > > A query with a left join was created and used successfully in NT without > ant > > problem, but when used on a Windows 2000 machine the query causes access > to > > crash. > > A: Converted the 2000 operating system to resemble an NT box > > B: Ran SFC > > Problem still persists, any suggestions. > > ========================== > > SELECT DISTINCTROW Customers.[Customer Name], Customer_Contacts.Contact, > > Customer_Contacts_Selected.templ_select, Customer_Contacts.E_mail > > FROM Customers INNER JOIN (Customer_Contacts LEFT JOIN > > Customer_Contacts_Selected ON Customer_Contacts.ID = > > Customer_Contacts_Selected.ID) ON Customers.Counter = > > Customer_Contacts.CustID > > WHERE (((Customers.[Customer Name]) Is Not Null) AND > > ((Customer_Contacts.Contact) Is Not Null) AND ((Customer_Contacts.E_mail) - Hide quoted text - - Show quoted text - Quote: > Is > > Not Null)) > > ORDER BY Customers.[Customer Name], Customer_Contacts.Contact;
Thu, 13 May 2004 14:06:37 GMT

Page 1 of 1

[ 3 post ]