Nope, I am the only one with access to access and these errors occur in the middle of the night. Sorry, I should have explained that.
Giles Roadnight http://giles.roadnight.name -----Original Message----- From: spike.org.uk [mailto:spike@;spike.org.uk] Sent: 30 October 2002 08:59 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Query giving me occasional errors Most likely someone somewhere has a the table open in Microsoft Access. If you open a table in Access, the jet engine will place a lock on the table stopping you from changing any of the data. Spike Stephen Milligan Team Macromedia - ColdFusion Co-author 'Reality Macromedia ColdFusion MX: Intranets and Content Management' http://spikefu.blogspot.com > -----Original Message----- > From: Giles Roadnight > [mailto:giles.roadnight@;goldcockerelbooks.co.uk] > Sent: 30 October 2002 09:46 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Query giving me occasional errors > > > Hi All > > Since upgrading to MX I am still getting > > Error Executing Database Query. [MERANT][SequeLink JDBC > Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] > Could not update; currently locked by user 'admin' on machine > 'THISTLE'. > > Errors a few times a day. Can anyone tell me anything more > about this? Last night I also got this error on the same SQL: > > Error Executing Database Query. [MERANT][SequeLink JDBC > Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] > Operation must use an updateable query. > > The Sql I am running is: > > insert into tracker > (RefURL, PageURL, RecordDate, TrackerID, SiteID, cftoken, cfid, > IPAddress) values('', '/Help.cfm', '30-Oct-2002', 113154, > 'GoldCockerel', '79327251', '124183', '66.196.72.57') > > Thanks Guys > > > Giles Roadnight > http://giles.roadnight.name > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
