ExcelBanter - Query a database on a server not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Query a database on a server not working (https://www.excelbanter.com/excel-discussion-misc-queries/41156-query-database-server-not-working.html)

r_sad

Query a database on a server not working

I've set-up a query on a database that's on our server and I get an error:
"UNEXPECTED ERROR FROM EXTERNAL DATABASE DRIVER (11270)", but if I save that
database to my local drive, the query works just fine. How can I make the
query work with the database on the server?

All times are GMT +1. The time now is 02:16 PM.