[AccessD] Initial value of an ANPK

Thanks, Susan. In the situation, however, I think that this is not going to
be the appropriate solution. I think it's time to dust off my knowledge of
replication and go back to that. I was very good at setting up Access
replication about 8 years ago, but since I moved to SQL it's been a while.
However, this app is in Access. I even wrote up how to do it, but can't
locate the document.

A.

On 12/6/07, Susan Harkins <ssharkins at gmail.com> wrote:
>
> You just create an append query Arthur and set the ANPK's field to one
> less
> than you want the first value to be -- just open a fixed query in Design
> view, choose Append from the Query menu, specify the table... run it.
>
> Open the table, delete the record you just appended.
>
> Susan H.
>
>