I am trying to set up a connection to an access database via OLE DB(ADO). The problem is that I do not see the provider I need in the list. The Provider I need is:
Access Database Engine OLE DB Provider
My set up: Crystal XI, Windows 7, Microsoft Access 2010 and I downloaded the Microsoft Access Database Engine 2010 Redistributable.
The File type for the database: Microsoft Access Database (.accdb)
Any thoughts/suggestions on how I can get the Provider available in my connection set up?