Clever Geek Handbook

Changing the autonumber field to a numeric data type

Is there a way to change the autoset field to a number datatype when the field is used by the primary key and linked to other tables?

+1


source to share


2 answers


First, you need to drop the relationship (relationship) between the table and any foreign key columns in other tables. Change the data type and then re-create the relationship.



+2


source


As far as I know, there is no way to change this. In Access 2007, it can be changed from Long Integer to Replication ID. In previous versions, I don't remember any way to do this - if I remember correctly, it was automatically set to Long Integer, but there is no way to control what Access does with AutoNumber.



Edit (question changed): You will have to drop the relationship with other tables to change it, once you drop the relationship you can change the type and then recreate the relationship.

+1


source






More articles:


All Articles