How are you connecting to Access?
If you are using code, than you have to set reference to Microsoft DAO 3.6 Object Lybrary.

Or you can use Microsoft ADO Data Control 6.0