>Here is the code. Connection to SQL is first established followed by:
>
>

>*get shipments from SSS with the Arrival Id present
>lnRetVal = SQLEXEC(lnConnHandle, "SELECT a.BillNr, a.ConfigCharEight, a.ScheduledShipDate, " + ;
>          								"a.RecordDate, a.PreSpecCarrierId, b.ProNumber " + ;
>   								 "FROM tblShipmentHeader a JOIN tblLoad b " + ;
>   								 		"ON a.BillNr = b.LoadId  " + ;
>   								 "WHERE a.ConfigCharEight IS NOT NULL "  + ;
>    							 "AND a.RecordDate > GETDATE() -6", "Results")
>
>
>
>*update Arrival dbf with the ship date and tracking number
>UPDATE a ;
>SET a.utext5 = b.ProNumber, ;
>	a.utext6 = CAST(b.ScheduledShipDate as char(30)) ;
>FROM (lcArrivalFilePath) a JOIN Results b ;
>	ON a.pieceid = b.ConfigCharEight 
>
>

>
>The code failes when trying to do the update due to the fact that the lcArrivalFilePath file is in use. My question was would adding OPEN lcArrivalFilePath SHARED help?
>
>Thank you,
>Daniel

No, it would not help. You first need to close the lcArrivalFilePath as it looks like it's used exclusively already.