John wrote:
One thing that is different with your code is the
following, which it doesn't have, does the code need it?


Most of the connection string can be omitted as they are default values
anyway. Looks like I was a bit too mean with what I left in!

Try adding
;Driver={Microsoft Access Driver (*.mdb)};UID=Admin
back into the connection string

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup