Cannot change field type

[Catalina]

I am using Access 2003.

In one of the tables I want to change a field from autonumber to number.
I get an error message saying that it is part of a relationship and I need to delete that in the Relationship Window first.

After I did that it still won't let me. I did a repair and compact but that doesn't help either.

I guess I can import everything into a new database but I hope there is a better (and quicker way) of resolving the problem.

All suggestions will be appreciated.

Catalina

 

[wazz]

if it's a primary key you'd have to remove that first.
or, you could create a new column (number) and copy the contents to the new column. delete and rename things as necessary.
hth.

 

[gemma-the-husky]

that does seem strange - i just changed a field from autonumber number to number with no problem. there must be something else going on.

although you cant turn it back to autonumber!

 

[Catalina]

Wazz,

I tried that, but it doesn't work.

For some reason the original relationship cannot not be removed.

I'll just make a new database and import everything from the old one.
It's a hassle but at least that works.

Thanks for the help.

Catalina