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

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8001
  • Karma: +211/-127
  • 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: 8001
  • Karma: +211/-127
  • 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!