Hi Imar - already put the IN query together - works great! thanks again -however while testing I received this error;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'WIRED01-2003'.

/sample_tracking/editprocess.asp, line 101

This was the update issue I was trying to recreate earlier - as far as I can tell the access database was open to insert data - and becasue of that wasn't able to update the data (line 101 is execute update) I thought access supported multiple concurrent connections - and this would only be one other connection - is there a way to close the table after the insert is done then update the table? Just picking your brain a little!

Chris