Hi

As the original poster I have been fascinated by the debate which has ensued.  I never expected this outcome.

I would like to point out again that the tables in the...

Absolutely terrific.  I now have something which works brilliatly.

Many thanks to you all

Paul

Hi Kenneth

Yes it would seem a pretty awful table.  It is really a reporting table from the main Oracle database - brought into SQL Server.

Thanks for your solution.  I'm amazed...

Thanks, Kenneth

I need to give a colleague access to this, so would prefer either a view, or a table which I could regularly update from a DTS package.

Paul

Apologies.

I have managed to sort this out myself.

Paul

Hi

I'm just back on this again and am astounded by the brilliant replies. 

Particular thanks for the superb code - I have learned a lot of new things from this. ...

Hi and thanks.

Yes I am using Access 2000.  The report consists of many fields, but the only one that needs to be limited is the memo.  I'm not quite sure...

Hi

I've just managed to get back on to this, so apologies for not replying immediately.  And I couldn't agree more about how helpful people are on this site.

I need to...

Hi Remi

Thanks for the reply.  The problem is that the number of characters can vary from 1 per line to none to a paragraph of continuous text.

Paul

This is terrific.  Both work for me.

Thanks very much for all your help - it is greatly appreciated.

Paul

This sounds great.

I have tried it but am probably being a bit thick.

I have a database called PT an a server called Hamlet.  I have created a local user on...

That's exactly right.

Many thanks

Hi

That would definitely work, but I am using Window's login rather than SQL login.  That means the person will retain his permissions.

Many thanks

Paul

Hi

Many thanks for your reply.  I'm sure the the View permissions would work fine.  However, I have a lot of tables and was hoping to find an easy way to...

Hi Yelena

Thanks for replying.  The table only hangs in QA when the package hangs - leading me to believe that the table (which is being processed within the package) is...