Let's put on the table first that MS Access has not been formally supported by CF since CF11. You can see that while it's listed in the "system support matrix" for CF11 (here), while it's no longer listed as a supported DB in the version of that document for CF2016 (here) or 2018 (here).
So you're pushing a rock up hill, in trying to keep it going (and of course many would decry anyone trying to use Access with CF still in 2019--and even someone trying to help folks wanting to do it).
But if you really are determined/compelled/feel required to get it to work, there were various solutions shared in this other thread on the topic, created in 2016 and updated into 2019, and multiple people reported particularly getting success from the steps shared by someone in this comment (with steps they got for Adobe, as a workaround).
FWIW (for future readers that may find this), as the title of that other thread indicated, those were for getting it running on 64 bit CF. There have been other discussions in the past on getting things working with 32-bit CF, but note that CF2018 no longer supports 32-bit (and bgbowling does refer here specifically to using CF2018).
If you do try this approach (in the other threads, from the 2016 era), let us know how it goes.
But again, folks, really: it's long past time to get off of Access, for use with a server like CF. Note that there are free alternatives like the Express edition of MS SQL Server (as well as MySQL, PostGres, and others), and tools to convert from Access to that.
/Charlie (troubleshooter, carehart.org)
7
Replies
AdChoices