Change autonumber to long

[RonB]

Anyone know how to change an 'autonumber' to a Long type using DAO, VBA
Currently I've got VBA to identify an 'autonumber' in a table by using TableDef:=
(where myf is a field in the table)
If myf.Attributes = 17 Then 'is autonumber

So thus identifies the field as autonumber
If I then add - myf.Attributes = 33
(I understand that 33 = Long)
I get error 3219 "Invalid operation" ---any suggestions?

 

[Rich]

Surely an AutoNumber can only be long anyway?

 

[RonB]

The issue is not that its Long its that its an autonumber

I just want to get rid of the autonumber attribute and leave
it as a long type only

Sri for confusion

 

[Tim K.]

Check this page out.

 

[RonB]

Thanks all replies - will check it out last reply page

Does seem to me TD that this is not allowed by Access
I can change a tabledef's name but not its Type nor Attributes?
using my current VBA