Jared, LOL, yeah it sounds like an Access issue. Actually we're using SQL 2k.
Another question though, by using a high isolation level will that slow the app down significantly? I read in the docs that there's a lot of overhead associated with it? Thanks, Ali >Ali, > >You'd be best off to use a CFTRANSACTION with a high isolation level, >like read_committed or even serializable. > >I'm gonna take a stab at this and guess you're using Access? > >Keep us posted! > >J > >On 4/19/05, Ali Awan <[EMAIL PROTECTED]> wrote: > > >-- >--------------- >------------------------------------- >Buy SQLSurveyor! >http://www.web-relevant.com/sqlsurveyor >Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203656 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54