RE: FN-FORUM: Stupid Access question

date posted 15th August 2005 16:08

If you can't use autonumber then you'l have to wrap it in a transaction
and do as you've suggested with a max(orderid) + 1



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


Thanks. I can't use autonumber in this particular case but normally you
right that is the way to do it.


Pam






----- Original Message -----=20
From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, August 15, 2005 4:28 PM
Subject: RE: FN-FORUM: Stupid Access question


>
> 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
>
>
> --
> 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
>
>
> --=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
>
>=20
--=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