Change autonumber datatype!

G

gp

Is there a way to change the autonumber datatype of a
field?

When I tried changing the type to number, it asks me to
delete the relationships in which the table is involved in.

I did delete the relationships, but still it wont allow me
to change the datatype.

Would appreciate any ideaS!
Thanks in advance
 
R

Rick Brandt

gp said:
Is there a way to change the autonumber datatype of a
field?

When I tried changing the type to number, it asks me to
delete the relationships in which the table is involved in.

I did delete the relationships, but still it wont allow me
to change the datatype.
Click to expand...

You cannot change it and have it stay an AutoNumber.
 
J

John Vinson

I did delete the relationships, but still it wont allow me
to change the datatype.
Click to expand...

It's a bit trickier than it appears to delete a relationship. Deleting
the table icon in the relationships window is purely cosmetic,
affecting the window display but NOT deleting the relationship.

Try opening the Relationships window, View all relationships, and
select and delete the *join line* rather than the table icon. You'll
be asked if you want to delete the relationship.

Then you can change the datatype, and subsequently reestablish the
relationship.
 
G

gp

John,

Thanks so much!! That trick worked!!
I did get the datatype changed!!

Thankyou
I appreciate it!
 
Top