Hi John,
The FieldType must be of Type: AutoNumber which you
can select from the DropDown in the 2nd column of the
table in DesignView.
It will create FieldSize of LongInteger.
If you link to an AutoNumber field then the linking
field must also be a LongInteger.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@...> wrote:
>
> I am trying to change a field type so that the Number increments 1 for each new record. After I go to Query Design, Close Table box, Click Data Definition and type in
>
> "Alter TABLE tbl_Items Alter Column BoxNumber COUNTER (1000,1)"
>
> I get the error "Invalid Field Data type"
>
> How can I fix this? I've tried changing the Data Type using Number and Text, but both result in the same error.
>
> Thanks,
> John
>
Tidak ada komentar:
Posting Komentar