Solved

wordpress ODBC Access

Posted on 2016-07-22
3
130 Views
Last Modified: 2016-07-22
1st time Trying to set up ODBC from a Website to my Access 2016 db.  Having trouble getting past the preliminaries. I understand that the first step is connecting to the data source.  I see in my ODBC Data Source Administrator (64-bit):
MS Access Database/64-bit/Microsoft Access Driver (*.mdb, #.accdb).  
Double-click on this gives an error
 "Unable to load odbcji32.dll" (twice),
then
"The operating system is not presently configured to run this application."

Found online instructions to repair this:
Windows 10: "Settings > System > Apps & Features", search for "access" and click on "Change" / "Repair".
Got stuck on the Apps & Features page--searching for "access".  No results found and no "Change or Repair" option listed

Where do I go from here?
0
Comment
Question by:Member_2_7968517
3 Comments
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 41724805
You have to use the bit version of the ODBC driver that matches the bit version of Access.  So, if Access is 32-bit, then the ODBC driver must be 32-bit.
0
 
LVL 5

Accepted Solution

by:
Eric C earned 250 total points
ID: 41724823
Microsoft now prefers to push out Office via "click to run".

Conveniently (for Microsoft), if you installed Access this way then you can ONLY connect to it from other Microsoft applications.

The 'workaround' is to install the standalone (and free) Microsoft Access Runtime.

Here is a link that describes what I mentioned above:
https://support.microsoft.com/en-us/kb/2874601

And here are links to download the free Access Runtime:

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255 

Microsoft Access 2013 Runtime
http://www.microsoft.com/en-us/download/details.aspx?id=39358

Microsoft Access 2016 Runtime:
https://www.microsoft.com/en-us/download/details.aspx?id=50040 


If these don't work, you may need to uninstall any current Runtimes you already have, repair Office and then reinstall the runtime.
0
 

Author Closing Comment

by:Member_2_7968517
ID: 41725477
Both very helpful.  Thanks very much.  Stay tuned, I'm very needy in this position.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question