RE: access not accepting insert statement

- 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 t

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 devel

Re: access not accepting insert statement

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 PRO

RE: access not accepting insert statement

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?

RE: access not accepting insert statement

are you locking the insert statement? Mark Smyth Macromedia Certified ColdFusion Developer Systems Union eBusiness Solutions 01865 880800 [EMAIL PROTECTED] -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 15:20 To: CF