Query crashes MS Access 2002

[NHelaMS]

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 ENGLIST
ON tblJobList.ACT=ENGLIST.ACT
SET tblJobList.Start = ENGLIST.ES, tblJobList.Finish =
ENGLIST.EF, tblJobList.RemDur = ENGLIST.RD
WHERE tblJobList.RemDur<>ENGLIST.RD;

Any help would be very appreciated.

Thanks!

 

[Golom]

I'm not sure what you are trying to accomplish here but the sub-query doesn't look properly formed.

SELECT * FROM ENGOUT
IN &quot;&quot; [dbase 5.0; J:\SchedProj]

looks like it needs a WHERE clause. The usual construct is something like

SELECT * FROM ENGOUT
WHERE MyField IN ([dbase 5.0; J:\SchedProj])

 

[Golom]

Sorry ... You are trying to reference a table called &quot;Engout.dbf&quot; in J:\SchedProj?

What do the double quotes do for you?

 

[NHelaMS]

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.