Author Topic: v15.2 & v16β – How to Reverse-Engineer a .accdb database  (Read 4080 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8135
  • Karma: +228/-128
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
v15.2 & v16β – How to Reverse-Engineer a .accdb database
« on: October 20, 2021, 01:05:27 pm »
While we can create a .accdb repository.  We want to reverse-engineer a .accdb database - to see what's in it.

I tried to link to it with ODBC, but the access driver we had crapped out.  Can it be done? If so, how?
The documentation doesn't seem to have any suggestions.

TIA,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8135
  • Karma: +228/-128
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: v15.2 & v16β – How to Reverse-Engineer a .accdb database
« Reply #1 on: October 20, 2021, 06:58:20 pm »
I found the solution...  Download the 32-bit ODBC driver (the 64-bit version seems to have problems) from this Microsoft site.  The driver allows the reverse-engineer of tables and views only.  ("still, better than a kick in the head")

HTH,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!