Hi Cheryl, It sounds as though MSDATE and STD# are used in a multi-column index. See if that does the trick. Good Luck, Manuel de Aguiar
McClure, Cheryl wrote: >I'm updating a database design to work with ODBC (using R:BASE version 6.5++ >Windows Build: 1.842xRT03). I'm changing a column name from STD# to STDNUM. >When I try to save the table I get the error message: > >-ERROR- As column MSDATE is used in another table, its type cannot be >redefined. (2942) >Unable to create/modify table. > >I am not changing MSDATE at all. MSDATE does exist in a couple of other >tables, but it is defined in all tables as a DATE. What is happing here? >How can I get around this problem? > >Thanks in advance. > >Cheryl > > > >
