Aaron,Thanks for the reply. Actually though I have done that. I thought it might be due to file lock...so I recoded it with a recordset (as in Neil's code) hoping that would fix it (setting recordlock to optimistic etc)...unfortunately it didn't make a difference.I finally threw in the towel and connect directly. No more problems that way. The weird thing is that when I connect to SQL2K through the DSN, I have no problems. A hundred people can pound away on the db with no problems. I think it is just Access....good db to prototype in but lousy db to do production with.
