cannot change field size due to relationship 2

[asinarrgh]

I have to change the field size of 10 fields in an existing table from 4 to 5. When I attempt the change I get an error message that says I cannot change the name or size of a field while a relationship exists. I have gone into the relationship window and removed all relationships (whether they pertain to the fields or not) and examined all queries that I have created to ensure that no relationships exist there. I still get the same error message. Can someone please tell me what I am doing wrong? Thanks

- jc -

 

[GingerR]

are you sure you are deleting the Relationship itself (the LINE in between the tables in the Relationship window) instead of just removing the table from the Relationship view?

 

[asinarrgh]

Yes,
Thanks for the reply...
yes, I am removing the line between the two tables.
I have removed the relationship, saved the database, closed the database, reopened it and still cannot modify the table. It is really strange to me since the fields that I am changing are not involved in ANY relationships.

Thanks for your help...any other ideas?
- jc -

 

[RickSpr]

If it says you can't change the name of a field that's involved in a relationship, then it must not be a Jet database, because Access allows you to rename fields in involved in a relationship.

You will need to use the administrative tools of the database management system that manages the tables to remove its internally defined relationships.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[asinarrgh]

Thanks GingerR and RickSpr...
It APPEARS that I have been misleading you.
I was getting an error msg about relationships, but my problem turned out to be that the table that I was trying to change the field size on consisted of combo boxes from another table.
I made a copy of the whole database, deleted the table that I was trying to change and then imported it back in from the copy I had made. I then modified the field size and everything APPEARS to be working normally. Thank you for your replys.
It appears that I never quit learning about this database... as soon as I get comfortable, I find another thing that I don't know.
Thanks again.
- jc -

 

[asinarrgh]

RickSpr,
You are right - I COULD rename the field, just not change the size. I was too quick in writing the first help request. Thanks again for your time.
- jc -