Access is single threaded by design. That means when two simultaneous
requests arrive Access will automatically queue them up in the order
received. How can you be sure both insert statements are arriving at the
same time and are correct in syntax?
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-----Original Message-----
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 7:20 AM
To: CF-Talk
Subject: access not accepting insert statement
I'm using coldfusion and access (ODBC) and having a problem. When
multiple insert statements arrive at the same time only the first insert
statement is accepted. We don't have that many users on the system
(Intranet) so it doesn't make sense to migrate from access.
Is there a way of queuing the insert statements, or any other way of solving
this problem?
Gilbert Midonnet
BrokerTec USA, LLC
(201) 209-7843
----------------------------------------------------------------------------
----------------------------------------------------
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
