1 Reply Latest reply: May 4, 2016 4:49 PM by Clever Anjos RSS

    Error Connecting to Access DB

    Yvonne Han

      Hi QV Expert

       

      I need some help connecting QV to access database. I've read a few community posts and there seems to be different way, but I haven't figured out a way that works for me:(

       

      Quite a few posts said install an Access Database Engine first, and that's what I did.  I have a 64 bit Computer and QV, but the MS office and Access Database Engine is 32 bit. Then I tried to Connect using OLE DB with Force 32 bit checked. Then I selected Microsoft Jet 4.0 OLE DB Provider.

       

      Capture. 2.PNG

       

       

      Then I choose my database. And got this error….

       

      Capture.PNG

      Any idea why?

       

      thanks

       

      Yvonne