Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using SQL to Join 3 Tables
Thank you for the suggestions, thecreator and scriverb. I tried both suggestions and Access still crashes when trying to open the recordset. I cannot remove the dbSeeChanges option because one of my tables has an identity column. When Access crashes, the information in the debug screen is...- jmunk
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using SQL to Join 3 Tables
I have a frontend database that is Access 2002 (originally written in Access 97) and the backend data is a SQL database. I need to join three tables in a SELECT statement to create a DAO recordset. My SELECT statement is: Criteria = "SELECT * " Criteria = Criteria & "FROM tblPendItems...- jmunk
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
