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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query crashes MS Access 2002
I'm not actually sure what the double quotes are doing for me. I copied the syntax our of the Access 2000 Developer's Handbook from Sybex and it worked for me in an UPDATE statement. It just does not seem to be working for me here.- NHelaMS
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Query crashes MS Access 2002
I am using the following code in my query and every time I try to close the SQL view and save the query MS Access crashes. Please tell me what I am doing wrong. UPDATE tblJobList INNER JOIN (SELECT * FROM ENGOUT IN "" [dbase 5.0; J:\SchedProj]) AS...- NHelaMS
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Help with updating a table and adding records
I am trying to set up a database that has Job ID, Description, Start Date and End Date as fields. Each week I will receive a .dbf file that is a table with the same fields but different headers. What I want to do is run something and update my original table (keying off of the Job ID code)...- NHelaMS
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
