I've seen that error before. I had to restart the CFExec process to get the
mbd file released. Sorry, don't have any better information than that. I
wonder why CFExec was holding on to it?
HTH,
Jeff Garza
Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Gilbert Midonnet
To: CF-Talk
Sent: 7/5/01 1:17 PM
Subject: RE: access not accepting insert statement
thx for all the replies.
> are you locking the insert statement?
yes, apparantly (see error msg below)
> How can you be sure both insert statements are arriving at the
> same time and are correct in syntax?
ah, hmmm, ah, like ... hmmm...ah, I dunno :>
"damnit jim, I'm a designer, not a developer."
> What exactly happens to the second insert statement?
Nothing server side. By nothing I mean that it doesn't get recorded in
the
db.
> Does it give an ODBC error or does it just not get inserted? (Should
have
sent it with my first post)
The error msg is below
ODBC Error Code S1000 (General error)
ODBC driver could not update; "currently locked by user 'admin' on
machine
'BTEC_NJIIS'
"The error occurred while processing an element with a general
identifier of
(CFQUERY), occupying document position (50:4) to (50:62)....
-- glm
------------------------------------------------------------------------
----
----------------------------------------------------
This message is for the named person's use only. It may contain
confidential, proprietary or legally
privileged information. No confidentiality or privilege is waived or
lost by
any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your
system, destroy any hard copies of it and notify the sender. You must
not,
directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if
you
are not the intended
recipient.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
