I'm back on this I'm afraid.  I need to install sqldmo.dll and related files - so I can use SQL Objects.  I've been searching the Internet and trying for hours to...

Thanks, Stewart

Dead right.  I originally had it mapped to the server as normal, but a copy adopted a drive letter. 

Silly mistake, and again many thanks

Paul

Hi Filet

Many thanks for your reply.  I agree and sympathise with your disappointment.  The whole thing seems pretty poor.

The work around I have used is to split the Access table...

Hi

Thanks for your reply.  I tried to import just one column to test the first 8 column hypothesis.  No go, unfortunately.

I also tried the 'Disconnected Editing' - right-click in...

Paul again:

I've found this for a 'Question of the Day' dated 8/4/2004. 

'Category: DTS

You are a DTS programmer that is trying to transform data from a large Excel file to...

Thanks Richard

I'm surprised it doesn't work somehow, as I culled the original code above from Northwind.adp

Paul

Thanks Richard

I can now use a batch file to install the Access front end and put the sqldmo.dll file in system32.  However the batch file terminates at this point.

What happens when I...

Hi Charles

I probably didn't explain myself properly - or I am misunderstanding what you are saying to me.  In References on the XP machines, the Microsoft SQLDMO reference doesn't exist...

Hi Charles

Thanks for the excellent reply.  Yes, I am sure this is the problem.

I'm not quite sure how best to best rectify this.  I am working on Windows 2000 server...

Thanks, Marshall

I'll check it out.

Paul

Hi George, Mike

For some reason my email didn't send me the responses to this question.  I guess I thought I wouldn't get any and just let it go....

So, now I...

Thanks Mike

That's teriffic.  I shall certainly be using that.

Paul

P.S I have just added another thread 'Lock adp'.  You obviously have an excellent knowledge of adps, and I wondered if you...

Yes, that's exactly what it was.

The great thing about this site is that any kind of helpful  prompt puts your brain back into gear after a hard day's slog.  I...

Excellent.  All now working.

I just needed someone to have a fresh look...

Many thanks

Paul

Hi Paul

Thanks for your help here.  I'll try running an sp from the before update event.

I should hopefully get the oportunity to try it later today - I'll keep you posted.

Many thanks...