Table Linked from a SQL server

[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

 

[Jeff Boyce]

Sarah

If I understand correctly, you have a table in a SQL database to which
you've linked. That doesn't create a table in Access, that just gives you a
way to see it (provided you have permissions from the SQL db side).

You may, however, be able to use table creation/modification SQL to change
it ... but if you don't "own" the SQL database, won't the owner and other
users have something to say?

 

[Sarah W]

Thanks Jeff. That is exactly what I meant. The text field
which I am trying to capture already can accomodate more
than 225 characters. So there is no issue of modifying the
SQL database table since I will be extracting what is
already in the database.

The problem is when I link that particular table to MS
Access(through ODBC) and run the query the result gets
truncated to 255 characters. I use MS Word mail merge tool
to link to the MS Access to create the report. If I create
a new table from scratch and change the text field to a
memo field and do the same link I am able to extract the
whole text string under that memo field which can have
more than 255 characters. Is there a way of manipulating a
Link table to achieve the same result.

Your help is greately appreciated.

Best Regards

Sarah

-----Original Message-----
Sarah

If I understand correctly, you have a table in a SQL database to which
you've linked. That doesn't create a table in Access, that just gives you a
way to see it (provided you have permissions from the SQL db side).

You may, however, be able to use table

creation/modification SQL to change