Quote Originally Posted by gibra View Post
This isn't JET provider, this is ACE provider.
Using JET doesn't work.
afaik ACE should work with .mdb to
there are a lot of possibilitys to try out
among others using a recordset (as you suggested)
if it does not work with ADO try with DAO
if it does not work with JET, try ACE
so i see at least 8 different methods to try

sql with ADO/DAO JET/ACE
recordset with ADO/DAO JET/ACE

but of cource if one asks a question about databases
including an example database would be the smart thing to do