View Single Post
Old June 20th, 2005, 04:23 PM
cedwards cedwards is offline
Authorized User
Join Date: May 2005
Location: , WI, .
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts

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!