asked on

Edit a ntext <Long Text> field/record in a table. easily!

Hi there,

I have taken over a SQL 2000 database and within it is a table which has
content for ASP web pages.
Some of the content is pretty long, and for some reason is displayed as
<Long Text> in the table, up returning all rows.
This particular field is ntext.

I need to change this text, how can i do this by ammending the existing
text? I need to see what is there!
I have tried to look into this and there is no "simple" way to do this!!!

HELP!, and be gentle, i am new to SQL and need to be spoon fed a tad ;-)

Hope you guys can help,

Thanx

SOLUTION

RichardCorrie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

FAWKE

ASKER

ok, so if i create an Access Db, with link tables to my SQL db, and create a form that edits this?
I am not a confident developer, so what might take you 15mins will take me 60mins ;-)

This is the view i get for SOME records in a column, in the SQL enterprise manager,,,,,

Il give that a go,

Any other ideas??

ASKER CERTIFIED SOLUTION

arbert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RichardCorrie

when you start Access 2000 you can create a new Project... this will take you to a wizard that will create the links etc to your db.

You can then edit the table directly (as per FAWKE's recomendation) or create a form over the table.

Richard

FAWKE

ASKER

wicked, well thanks guys.... all sorted, im gonna make the changes and issue the points,

Thanx again.. what a good job you guys do...

arbert

Make sure you have a valide Primary key on the table or Access won't let you edit it....

Edit a ntext &lt;Long Text&gt; field/record in a table. easily!

Edit a ntext <Long Text> field/record in a table. easily!