Does Database Builder work with MS Access 365

[Eiberle]

Hi all,

I am using EA16 64 bit (Build 1605) and I want to import the database schema from an MS Access 365 database (also 64 bit). I defined a connection using the Access 2007 format and set it to the active connection.

When I select the Import DB schema for the database, it seems the information about the tables in the access database cannot be read, so it only shows the message "Schemas are not supported".

Is this possible at all? Maybe somebody can provide me a hint - I have spend already a lot of time in searching the documentation and the web for the solution how to get this running.

I hope somebody can help me here.

Thomas

[Paolo F Cantoni]

Hi, Thomas,

We've been using both v15.2 and the 32-bit v16 to reverse engineer *.accdb databases via an ODBC connection with Database Builder.

Can you try any of those alternatives?

HTH,
Paolo

[Eiberle]

I can only use the 64 bit Setup. I have just tried it with ODBC but I still receive the same result. Must I specify something special in the Connection string? In the ODBC setting there is the parameter UID set to admin. In th database I have not specied any special role like admin.

[Paolo F Cantoni]

I can only use the 64-bit Setup. I have just tried it with ODBC, but I still receive the same result. Must I specify something special in the Connection string? In the ODBC setting, there is the parameter UID set to admin. In the database, I have not specified any special role like admin.

I think we downloaded a special driver for use with the v16 64-bit to give access to access (pun intended).  I just checked, and I can reverse engineer the above database with the 64 -bit version 16.

The best I can do is offer our ODBC DSN

Code: [Select]

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb, *.accdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=<Specify>
DBQ=<Specify>

I hope this helps.
Paolo

[Eiberle]

Hi Paolo,

I think we downloaded a special driver for use with the v16 64-bit to give access to access (pun intended).

This is exactly what needs to be done, thanks for that.

I have double-checked the documentation once more, and there it is stated that EA does only support Access 2013. So I have downloaded the Access 2013 Runtime from the MS homepage (e. g. you find it here: https://www.microsoft.com/en-us/download/details.aspx?id=39358) and installed it. After that I was able to import at least the table, the other stuff I have to check.

Thanks for the support here. I hope the hint that you need this Runtime will make it to the EA documentation one day  or even better support the most recent version 

Thanks,

Thomas

[Paolo F Cantoni]

Hi Thomas,

Last week, I reverse-engineered a complex MSA Application (in fact, the application we use to manage our EA repositories directly).  I found that the tables were reverse engineered; however, NO distinction appears to be made as to whether the table was a local or a linked table.
All forms of queries were reversed, but action queries DID NOT get the dependency links that normal view (SELECT ? FROM) queries get.
Macros were not reverse engineered as were not Modules.

Do you have any thoughts as to whether we should put in a feature request to get this rectified?

Paolo