I haven't seen that problem. What exactly happens to the second insert
statement? Does it give an ODBC error or does it just not get inserted?
Maybe you need to upgrade your MDAC.
-Bill
brainbox
----- Original Message -----
From: "Gilbert Midonnet" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 05, 2001 10:20 AM
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
