Thanks Sabotta, it all works fine now.

I am stumped on another issue though ... If I want to write individuals appointments to indivdual spreadsheets for emailing later on how do...

Thanks for your input all!

I found the offending bits COP last week .... it was a bit of VBA code which was trying to update one of the tables. As...

Hi,

I sorted that error out by undoing all I had previously done i.e upsizing using the Access database tool and redoing it using SSMA for Access and it now throws...

Hi SSC,

I can see the linked tables in Access and can create views using them.

R