Table Linked from a SQL server

  • Thread starter Thread starter Sarah W
  • Start date Start date
S

Sarah W

HI Mates

My Problem is like this. When you create a table by
linking to a Table from a SQL database( through ODBC query
say for example), Is it possible to change the format of
the linked table. I want to change the text field to a
memo field so that I can have more than 255 characters.

Is there a way around this.

Thanks Guys. your help is surely appreciated.

Best Regards

Sarah
 
Nope.
You can't do that.

You have to have the DBA change the field and then oyu have to delete and
re-link the table for it to recognize the new data type.
 
Back
Top