1

I am familiar with reading mdb files with use of Microsoft.Jet.OLEDB.4.0. My case is that I would like to create .net core application, which could be run on Linux. Real question: how to read .mdb file on linux(and windows) using .net core?

I tried EntityFramework.Core.Jet but with no success.

Kula
  • 125
  • 3
  • 15
  • The following may be helpful: https://stackoverflow.com/questions/55696920/error-could-not-load-type-system-data-oledb-oledbconnection-from-assembly-system – Tu deschizi eu inchid Mar 05 '22 at 13:12

1 Answers1

0

You can use:

  • Free and open-source ODBC driver from MDB Tools
  • Wrap mdb-export (perf comparable with odbc) or mdb-json from MDB Tools with CliWrap (for read-only purposes)
  • Use Jackcess via IKVM
  • Commercial ODBC driver from Easysoft
  • ODBTP to remotely access Win32-based databases (you need some windows based server with your MS Access database)

I described in more detail how you can do this here https://stackoverflow.com/a/75565707/2828480

I'm not sure what provides the most complete feature-set if you need to do something other than basic read operations. I've never tested ODBC driver from Easysoft but since it's commercial I'd assume it's comparable to the official Windows one. Other than that maybe Jackcess if you don't care about SQL or UCanAccess if you care about SQL.

Unfortunately there aren't any other options I can think of. If you have other suggestions feel free to edit or comment.

Konrad
  • 6,385
  • 12
  • 53
  • 96