I am implementing some banner rotation/ad tracking stuff
and am getting a fair number of the following errors in
my CF application log (lightly edited for clarity):
Error,TID=178,06/14/00,04:10:45,
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access 97 Driver]
Couldn't update; currently locked by user 'admin'
on machine 'NEPTUNE'.
SQL = "INSERT INTO Views( SessionID, PositionID, AdID )
VALUES( 'ADTRAX_1807_68186843', 4, 6 )"
At times, this site can get busy so there is a lot
of these "INSERT" statements going on. I remember
something about MS Access doing page locks and not
releasing locks right away...
Any thoughts/suggestions?
TIA
Joe Tartaglia
High Caliber Systems, Inc.
212-684-5553
------------------------------------------------------------------------------
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.
