Hi Nils - thanks - that was my expectation but its great to get confirmation.

Cheers

Allen

Thanks cafescott

Hi Sam, thanks for this. I'm going to give it try and will post back.

Happy New Year!

Allen

Now I really _do_ feel like a Luddite.

As the OP its comforting to know the topic is still alive!

Can anyone comment on the Web options in Access 2010?

Allen

Thanks CozyRoc, I hadnt thought of the MSXML installation. Is that Ivan?

My Best error (I have lots) was

SELECT * FR0M MyTable

deleted

My bestr error ( I hve lots) was this.

SELECT

Thanks - I was probably not very clear, I just use Access if I need a front end. The back end is always SQL. A lot of my DBs are...

Hi Thanks - good idea about a set schedule. It will probably be on the hour (the client will of course want it more often).

I was going with mirroring...

Thanks all who posted. PsExec did the trick first time with no fuss. Brillliant!

Just a note for anyone else trying the same thing;

1 The help file supplied with PsTools...

Thanks Alvin - I had not heard of that before.

Will post back.

Cheers

Allen

Thanks to all,

I had not heard of EverNote, and I thought I had not heard of MS OneNote. I think I now remember OneNote as being the killer app for...

Thanks Baskar, works a treat - I think I was making things difficult for myself by changing the column definitions in the generated create table script.

Cheers

Allen