Thanks, David

I knew there was an easy solution here - I just couldn't see it.

Thanks, again for your time.

Paul

Thanks everybody for taking the time to help.  I apologise for being so tardy in replying - I've been off for the Chrismas holidays.

Well I tried pretty well everything, to...

Hi Vic

Thanks for answering.  I seem to be having a few problems with this subform.  I imported it originally from a legacy adp.  When I change the vba, I sometimes...

Just an addition.

I have set myself as dbo for the database on the linked server.  Both the main server and the linked server are set for both Windows and SQL...

Hi

MS certified (usually a trusted method) doesn't do it.

Which set options do you mean?  Could you please point out which and where?

Many thanks again.

Paul.

Hi

But mine just hangs in create View (but works in QA).  I can't rename or save...

Any ideas?

Many thanks

Paul

Hi

Many thanks for your help.  I need to get this one person to login and test your sp.  I sure hope to avoid re-installing SQL Server.

I much appreciate your...

Hi

Thanks, very much.  I knew the answer was simple, but I just couldn't spot it. 

Thanks again

Paul

Hi Billy

Great additional help to Joe's article.

Thanks for this.

Paul

Hi Joe

I really enjoyed this article.  I am not a SQL expert in any way, and found the step by easy step approach excellent.  I really feel I have learned...

Hi Balmukund

Thanks so much for your reply.  I'm finding this problem difficult to understand.

I went through your outlined procedure.  All was checked as you described:

'Allow Inbound' checked

'Allow Outbound' checked

('Allow Remote...

OK, all sorted.

The probem with the XP clients which didn't work was to re-install SP2???  Don't know why - but it worked........

Best wishes

Paul

Hi Andy

Sure.  Posts on this excellent site are very helpful all round.

However, tempering the success - SQLDMO loads on some of our XP clients - but not on others.  I'm now...

Hi

I agree, this is a great site.  However, I still don't seem to be able to find 'Max characters per delimited column' under OLE DB properties for the Source. ...

Hi

Success.

With a bit of fiddling, I've managed to do it with the help of:

http://support.microsoft.com/kb/q248241/#appliesto

It works excellently.  A good way to distribute without having to install SQL Server Client on...