RE: FN-FORUM: Stupid Access question

date posted 15th August 2005 15:49

Begin transaction and end transaction - but why not use the
datatype-autonumber ?

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
WHITTAKER
Sent: Monday, August 15, 2005 4:19 PM
To: Andy Macnaughton-Jones
Subject: FN-FORUM: Stupid Access question


I can't find the answer on google. I have an Ecommerce site using Access
and a new Order ID is obtained by selecting the highest one on the
Database and adding one. If two people access it at the same same time
then they can end up with the same number. How do I lock the table in
Access so that the second person can't access it until the first person
has written their Order. Is it "Lock table" or "set Transaction"?

Thanks
Pam=20


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html