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

Yeah, it does support multiple concurrent connections. However, I think you'll run into problems when you have the database open for design in Access on your desktop / server. If, for example, you're changing the design of a table you get this error.

It could also be a permissions issue, where ASP cannot create the .ldb file. Check this FAQ for more information: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=263

However, I don't think this is the problem in your case as you can successfully insert and update records. I think you should just close Access on the server and everything will be fine....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Teardrop by Massive Attack (Track 3 from the album: Mezzanine) What's This?

Hi Imar,

The access issue had to do with some of the test data I had put into it - I can only recreate the problem on about 10 of the different locations with data - and these were areas I had just made up data when I started building the pages - Once I removed all of the garbage data everything worked flawlessly - incidently I tested it by inserted 100 records at one time - perfect - pretty quick considering - overall this part of the tracking system has been a real learning experience (you can't even realize how much you don't know until you start playing with the code)

Again, I appreciate your help - I am sure you will be hearing from me again soon (I am building a section for queries next) I will try not to take all of your time!

Chris

You're welcome. Glad it's all working now.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Blackout by Muse (Track 9 from the album: Absolution) What's This?