Change autonumber datatype!

  • Thread starter Thread starter gp
  • Start date Start date
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
 
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.
 
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.
 
John,

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

Thankyou
I appreciate it!
 
Back
Top