Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    QuickBooksDev is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    9

    16 didn't work either. Same error message.

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    OK, one more. You never actually said that the code fails on the posted lines; just the error message and what you've used to try to fix it.
    - Is it vba code and does it fail on that line? If not, you should post the code.

  3. #18
    QuickBooksDev is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    9
    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Database1.accdb;




    I gave up on using the ACE connection string and instead used
    DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydatabase.mdb
    which worked with my 32bit app with a 64 bit access. It also worked on a test 64 bit app with a 32 access.


    Don't understand why this has been so difficult.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Provider/Customer Hub help!
    By cballew in forum Forms
    Replies: 3
    Last Post: 05-16-2018, 12:55 PM
  2. provider Microsoft.Jet.OLEDB.4.0 cannot be found... (?)
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 03-07-2017, 01:31 PM
  3. Provider of CurrentProject
    By Joakim N in forum Programming
    Replies: 2
    Last Post: 11-13-2016, 11:53 PM
  4. OleDB Provider is not registered
    By Perceptus in forum Access
    Replies: 1
    Last Post: 01-22-2015, 01:35 PM
  5. How to import data with OLE DB provider for ORACLE?
    By medusa3604 in forum Import/Export Data
    Replies: 3
    Last Post: 12-16-2014, 01:05 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums