5
  • I am using visual studio community 2017
  • Access 2010 - 2016
  • I can import an access file I created
  • File sent from client contains(tables, queries, forms, macros, and modules)
  • Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\jeremiah\Documents\Batching.accdb
  • The client sent me another basic file, was able to open without a problem

So I been through all current StackOverFlow solutions for people reporting the unrecognized database error and none of them have been useful.

My only theory is that the database they are using is to complicated to be used as a data source for visual studio.Do you have any suggestions?

Avinash Singh
  • 4,970
  • 8
  • 20
  • 35
Jeremiah S.
  • 411
  • 1
  • 4
  • 22

2 Answers2

8

I may not tell you what the problem is but I solved this issue before by resaving the database file as Microsoft Access 2003. Goto Save Database As Access 2002-2003 (*.mdb) and then use the new file.

Mubarek
  • 2,691
  • 1
  • 15
  • 24
  • That did it, thought I wish I didn't have to change the format. I am not sure if that will affect the client's workflow or if they will lose any features. – Jeremiah S. Nov 10 '17 at 19:04
3

You need use ACE.OLEDB 32 bits in Visual studio connection. (click in Advanced... button in Add Conection screen) enter image description here

The visual studio try use of Jet.OleDB not more supported.

Marco Antonio Quintal
  • 580
  • 3
  • 14