can't find a reference for Microsoft.Office.Interop.Access in visual studio 2017 C#

Asked May 13 '19 at 05:28

Active May 13 '19 at 05:28

Viewed 400 times

I am trying to open a C# winforms VS 2015 project in VS 2017 and managed to get the right references for everything except for Microsoft.Office.Interop.Access. when i imported Microsoft.Office.Interop.Access.Dao I got Errors for all my uses of this namespaces:

The type or namespace name 'Controls' does not exist in the namespace 'Microsoft.Office.Interop.Access'.

The type or namespace name ' AcFormOpenDataMode' does not exist in the namespace 'Microsoft.Office.Interop.Access'.

The type or namespace name ' AcView' does not exist in the namespace 'Microsoft.Office.Interop.Access'.

asked May 13 '19 at 05:28

Achinoam

1

The Interop requires Microsoft Office to be installed and there is a different version of the Interop for each version of Office. The Interop is very slow and converts the c# to a series of script language commands that Access recognizes. – jdweng May 13 '19 at 05:42
what do you mean by installing Microsoft office? – Achinoam May 13 '19 at 05:55
And why does Microsoft.Office.Interop.Excel work fine? – Achinoam May 13 '19 at 05:56
@Achinoam because you there is installed MS Excel and no installed MS Access? – vasily.sib May 13 '19 at 05:57
@Achinoam, also, when installing this MS Office products, you must enable features called ".NET programming support" (or something like that). – vasily.sib May 13 '19 at 06:00
@ vasily.sib thanks. you are right – Achinoam May 13 '19 at 06:01
@vasily.sib thanks! – Achinoam May 13 '19 at 06:10
https://stackoverflow.com/questions/21013912/can-i-still-use-microsoft-office-interop-assemblies-with-office-2013 – Hans Passant May 13 '19 at 08:31

can't find a reference for Microsoft.Office.Interop.Access in visual studio 2017 C#

0 Answers0