Creating AutoNumber Field Problem

[Anatoly Kurilin]

Hi, I did not find in Help the way for creating AutoNumber field in code.
I've tried to adapt these lines for that purpose
Set fldClientID = .CreateField("C lientID", dbLong)
.Fields.Append fldClientID

but there's no constant dbAutoNumber in Access.

AK

[rkc]

Re: Creating AutoNumber Field Problem

Anatoly Kurilin wrote:[color=blue]
> Hi, I did not find in Help the way for creating AutoNumber field in code.
> I've tried to adapt these lines for that purpose
> Set fldClientID = .CreateField("C lientID", dbLong)[/color]

fldClientID.Att ributes = dbAutoIncrField
[color=blue]
> .Fields.Append fldClientID
>
> but there's no constant dbAutoNumber in Access.
>
> AK
>
>[/color]