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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked table column type changes from text to memo 1
Extracting Long String Fied from SQL Server to Access 2003 5
Linked tables to SQL 1
Sql Server linked table and NULL bit fields 2
SQL Custom Data Types Not Visible In Access Linked Tables 1
Linked table field limit problem 3
Problem with ODBC linked tables in Access 2003 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top