access sequence?

[kriz]

HI
Does ms access support sequences?
If not, how can i create auto increment column type from the end user
application ?
<Im using Visual Studio 2003>

thank you in advance for Ur assistance

[Jerry Boone]

Re: access sequence?

Sure,

Make a column in the table your querying and set it to "Autonumber " type.

When you are working in .net with ado.net you can insert your row into a
datatable or dataset and after committing the update you can read the column
value back in. You know, in case you are adding child records, providing a
tracking number, and so on.

--
Jerry Boone


"kriz" <kriz@vp.pl> wrote in message news:dvpimv$cl0 $1@news.lublin. pl...[color=blue]
> HI
> Does ms access support sequences?
> If not, how can i create auto increment column type from the end user
> application ?
> <Im using Visual Studio 2003>
>
> thank you in advance for Ur assistance
>
>[/color]