Share via

access and visual studio data connection

Anonymous
2019-04-17T19:48:37+00:00

I have read many post regarding connection between access db.accdb file and visual studio.

I have office 2016 and visual studio 2017 and can not get studio to read a accdb file.  has anyone figured it out?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-04-23T00:01:44+00:00

After you select Access oleDB - then before you browse to the file, click on advanced, and make sure it using ACE as opposed to JET.

It changes automatic, but that assumes that ACE is installed. If you don't see ace in this dropdown, then it likely not installed correctly. Also, try installing the x32 bit version of the ACE provider - not the x64 bit version.

So, I would grab the x32 bit version from here:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Albert D. Kallal (Access MVP 2003-2017)

Edmonton, Alberta Canada

edit:

The drop down I am talking about after you hit advanced button in your dialog is this one:

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

DaveM121 891K Reputation points Independent Advisor
2019-04-18T13:02:51+00:00

Hi James, sorry, I was offline,

Please check the solution on this thread, you may be missing Microsoft.ACE.OLEDB.12.0

https://stackoverflow.com/questions/23160313/un...

Was this answer helpful?

1 person found this answer helpful.
0 comments

10 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 891K Reputation points Independent Advisor
    2019-04-18T06:24:25+00:00

    Hi James

    Have you followed the procedure on this page below for adding an accdb file as a data source to your WinForms project?

    https://docs.microsoft.com/en-us/visualstudio/d...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-04-17T22:35:35+00:00

    visual studio 2017.  win forms and vb code.  in newer access(accdb) you can have an attachment field.  however, currently I can only read the older access file(mdb) with my visual studio.

    Was this answer helpful?

    0 comments
  3. DaveM121 891K Reputation points Independent Advisor
    2019-04-17T19:55:01+00:00

    Hi James

    What type of application (WinForms, WPF . . etc.) are you creating in Visual Studio and what coding language(s) are you using to create that application?

    Was this answer helpful?

    0 comments