Usually that means someone has access running with that database open in
design or databiew mode...
> -----Original Message-----
> From: Joe Tartaglia [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 14, 2000 9:59 AM
> To: [EMAIL PROTECTED]
> Subject: ODBC Error-MS Access / locking problem
>
>
>
> 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.
>
------------------------------------------------------------------------------
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.
