Go Back   Access World Forums > Apps and Windows > Other Software

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-07-2017, 12:37 PM   #1
grahamvb
Newly Registered User
 
Join Date: Aug 2013
Posts: 57
Thanks: 12
Thanked 3 Times in 2 Posts
grahamvb is on a distinguished road
Visual Studio 2017 Community unable to read Access .accdb files

In Windows 10 pro, I am using Visual Studio Community 2017 (VS), V 15.4.4, to create a Windows Forms interface to some existing Microsoft Access (.accdb) tables.

When I attempt to establish a data connection from VS, using the process shown at <https://docs.microsoft.com/en-us/visualstudio/data-tools/connect-to-data-in-an-access-database-windows-forms> I discover that the Office 2016 (365 Pro Plus) subscription did not install the “Microsoft Office 12.0 Access Database Engine. (Step 9)

So, as instructed in step 9, I proceed to <https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734> download the, “AccessDatabaseEngine.exe” file and follow the installation instructions.

When “AccessDatabaseEngine.exe” runs, the following message appears:

“You cannot install the 32-bit version of Microsoft Access Database Engine 2016 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2016, you will first need to remove the 64-bit installation of office products. After uninstalling the following products, rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2016:

"Office 16 Click-to-Run Extensibility Component 64-bit Registration”

Then after clicking “OK” in the above error message, I get:

“Installation ended prematurely because of an error.”

No additional information is provided.

In Control Panel > All Control Panel Items > Programs and Features, I do not see any reference to “Office 16 Click-to-Run Extensibility Component 64-bit Registration.” The only thing about Office is “Microsoft Office 365 ProPlus – en-us,” and that only allows various repair options for the complete Office installation.

All the Office modules, Access, Word, Excel, etc. are 32-Bit.

Any Ideas?

grahamvb is offline   Reply With Quote
Old 12-07-2017, 12:38 PM   #2
jleach
Newly Registered User
 
jleach's Avatar
 
Join Date: Jan 2012
Location: New York, NY
Posts: 308
Thanks: 16
Thanked 70 Times in 70 Posts
jleach will become famous soon enough
Re: Visual Studio 2017 Community unable to read Access .accdb files

Try removing the CTR Extensibility: https://community.spiceworks.com/top...s-into-another

(I ran into this the other week and was a pain to resolve)
__________________
- Jack D. Leach

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Microsoft MVP 2012-2016
jleach is offline   Reply With Quote
Old 12-07-2017, 01:07 PM   #3
grahamvb
Newly Registered User
 
Join Date: Aug 2013
Posts: 57
Thanks: 12
Thanked 3 Times in 2 Posts
grahamvb is on a distinguished road
Re: Visual Studio 2017 Community unable to read Access .accdb files

Thank you for the best looking answer so far. Do you know what the consequences of removing the "Office Click-to-Run Extensibility Component" (12f563b9.msi) might be to my Click-to-Run Office 365 Pro Plus installation?

grahamvb is offline   Reply With Quote
Old 12-07-2017, 01:19 PM   #4
jleach
Newly Registered User
 
jleach's Avatar
 
Join Date: Jan 2012
Location: New York, NY
Posts: 308
Thanks: 16
Thanked 70 Times in 70 Posts
jleach will become famous soon enough
Re: Visual Studio 2017 Community unable to read Access .accdb files

Admittedly, I don't know what sort of side effects this may have. I can find 100 posts where people did this to "fix" their installation issues with no complaints otherwise, but I can't find any documentation on what this thing actually does.

I'll ask around a bit and see if I can find out.
__________________
- Jack D. Leach

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Microsoft MVP 2012-2016
jleach is offline   Reply With Quote
Old 12-08-2017, 04:29 PM   #5
jleach
Newly Registered User
 
jleach's Avatar
 
Join Date: Jan 2012
Location: New York, NY
Posts: 308
Thanks: 16
Thanked 70 Times in 70 Posts
jleach will become famous soon enough
Re: Visual Studio 2017 Community unable to read Access .accdb files

Apparently this installs the PIAs: https://msdn.microsoft.com/en-us/library/15s06t57.aspx

(I didn't read through the link enough to know what that means in practical terms).

__________________
- Jack D. Leach

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Microsoft MVP 2012-2016
jleach is offline   Reply With Quote
Reply

Tags
access 2016 , visual studio 2017 , windows 10 pro

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Learning resources for Visual Studio 2017 isladogs Other Software 1 08-22-2017 04:26 AM
Does the Visual Studio Community Version support Office 365 Development? prabha_friend General 0 08-08-2016 02:24 AM
Visual Studio and Access mfaqueiroz Modules & VBA 7 05-13-2016 07:04 AM
difference in visual basic on access and visual studio iworkonline Modules & VBA 1 05-26-2010 01:49 PM
visual studio and access NigelShaw General 1 05-24-2008 02:37 PM




All times are GMT -8. The time now is 02:04 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World