Solved

wordpress ODBC Access

Posted on 2016-07-22
3
168 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 36

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Integrating blogs between to separate WordPress websites 4 30
Google drive Permission Error 43 49
Null or "" 28 53
Sharepoint list to Access database 9 50
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
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 …

749 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