View Single Post
  #2  
Old January 11th, 2010, 07:20 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Can't change data type

Steve,

Sounds like you missed one... In the Relationships Window click the show all
button and delete the remaining ones and try changing your field size again.
Also, if this database is split then you need to do this in the back-end,
doing this in the front end has no effect on the acutal relationships.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve Stad" wrote in message
...
I was trying to update field size in table design. I get a message saying
'You can't change the data type or field, it is part of one or more
relationships. If you want to change the data type of this field, first
delete its relationship in the Relationships window.
I have deleted the relationship and I still get this message when trying
to
update the field size.