Panic over guys - thank you all for your suggestions. The solution was that in SQL Server Configuration Manager / SQL Server Network Configuration / Protocols for SQLEXPRESS TCP/IP...

I've got loads of experience writing queries and views in SQL and am keen to build on this, using this exisiting database as the inital source of data.

I hope to...

Hi

Yes all seems fine within SQL, the tables are there, I can write queries ok, it's setting up the OBDC links are you describe that throw the error I quoted.

This...

Hi Ray thanks for the response, yes the database auto-created with the data import and I can successfully write queries on it in SQL. There are currently 4 tables,...