NeoBookDBPro - Access create difficulties
Quote from PaulJonestindall on November 25, 2019, 1:39 pmI have a similar problem to another topic here.
My issue is with NeoBookDBPro and specifically with accdb files. The documentation suggests the dbpCreateAccessDatabase action should be able to work with both MDB and ACCDB files. The error I get is: Class not registered. I understand I have to install some additional Microsoft software but I'm not sure what in order to be able to take advantage of the ACCDB files.
I have a similar problem to another topic here.
My issue is with NeoBookDBPro and specifically with accdb files. The documentation suggests the dbpCreateAccessDatabase action should be able to work with both MDB and ACCDB files. The error I get is: Class not registered. I understand I have to install some additional Microsoft software but I'm not sure what in order to be able to take advantage of the ACCDB files.
Quote from luishp on November 28, 2019, 1:02 pmHi @pauljonestindall,
Sorry for the delay. I've asked Dave about this as I was unsure about the answer.
This is his email. I hope it helps.I found this in an old email...
If you're using the "click-to-run" version of Office 365, then you probably don't have the driver that allows third party apps to open Access databases. Click-to-run versions only downloads and installs files that it thinks you need. According to Microsoft:
You must install an MSI installation of the Microsoft Access Database Engine from one of the following sources so that the calling application can locate the driver and provider.
Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-u
s/download/details.aspx?id=132 55 Microsoft Access 2013 Runtime
http://www.microsoft.com/en-us
/download/details.aspx?id=3935 8 Here’s the full article:
There are probably newer versions of these files now.
Other than that, I’m not sure what to suggest.
Sincerely
Sorry for the delay. I've asked Dave about this as I was unsure about the answer.
This is his email. I hope it helps.
I found this in an old email...
If you're using the "click-to-run" version of Office 365, then you probably don't have the driver that allows third party apps to open Access databases. Click-to-run versions only downloads and installs files that it thinks you need. According to Microsoft:
You must install an MSI installation of the Microsoft Access Database Engine from one of the following sources so that the calling application can locate the driver and provider.
Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-u
s/download/details.aspx?id=132 55 Microsoft Access 2013 Runtime
http://www.microsoft.com/en-us
/download/details.aspx?id=3935 8 Here’s the full article:
https://support.microsoft.com/
en-us/help/2874601/can-t-use-t he-access-odbc-driver-or-oledb -provider-outside-office-click -to-run-applications There are probably newer versions of these files now.
Other than that, I’m not sure what to suggest.
Sincerely