ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'HOSTING1'. The database I was accessing was not open. What would cause it to be locked? The only other thing I can think of is, I am using an Access database for client storage. Since I'm not NT savvy, I'm doing everything in my power to store as little as possible in the registry. Could it have been that? I was setting a session on that page. But still, why would it be locked when it wasn't open? Could it have something to do with limiting the number of concurrent selections? I thought that would just put the query action in queue. Regardless, I opened the database and looked, and mine was the only cfid being written at the time. And the database I was accessing through my application was just doing a Select, not an Update. And while we're on the subject of client storage in a database, would it be a good idea to go in occasionally and delete records? How large should I let it grow. Sign me, Perplexed :) Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.