Thanks for the suggestions so-far. The DSN is correct, I have tried a simple select statement from the SQL server using a SQL connection. This returns a recordset with no...

Thanks for the suggestion. Unfortunately I had already tried that and got the following error:

 Microsoft JET Database Engine error '80004005'