Sparx Systems Forum
Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Paolo F Cantoni on September 19, 2024, 11:51:27 am
-
Hi all,
I urgently need to reverse-engineer an MS Access AccDB database. I was able to do this on previous versions and environments (see https://sparxsystems.com/forums/smf/index.php/topic,47223.msg275477.html#msg275477 (https://sparxsystems.com/forums/smf/index.php/topic,47223.msg275477.html#msg275477)), but everything I've tried for the last three days has come to naught!
I'm currently running under Windows 11 (64-bit, of course) and EA v16 or v17 (I have both 64-bit and 32-bit installed) and Office 365. I can access and edit the .accdb file using MS Access. What process will enable me to reverse-engineer it? ODBC doesn't seem to be working as it seems to expect a .mdb file, regardless. I can't save the .accdb file as a .mdb file as it contains incompatible components.
Any assistance is greatly appreciated.
Paolo
-
I don't have your environment, but have you simply tried to rename it to .mdb?
q.
-
Hi q,
The internal file structure of an accdb file is probably quite different from that of an mdb file, so I don't expect it to work. But I have nothing to lose.
I'll give it a try and report back.
Paolo
[EDIT: As expected, it says: "Illegal DB format"]
-
I am developing a C# tool that opens eap/eapx/qea/qeax files as databases and allows launching queries to it. I am using a standard database connection using the connection string $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={inputFile};" where inputFile is the variable containing the full path to the file to open.
I'm not sure if this will work for your accdb case, but maybe it's worth trying?
-
I am developing a C# tool that opens eap/eapx/qea/qeax files as databases and allows launching queries to it. I am using a standard database connection using the connection string $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={inputFile};" where inputFile is the variable containing the full path to the file to open.
I'm not sure if this will work for your accdb case, but maybe it's worth trying?
Thanks for the suggestion Victor.
But the syntax of the connection details for reverse engineering doesn't allow specifying the providers that way. Also, I can already open the DBs of the types you mentioned using the existing mechanisms as you do; the problem is that those providers don't seem to work for accdb files.
I've submitted a support request, so we'll see what Sparx say.
Paolo
-
Googling for "convert accdb to mdb" pointed me to a (German) Mickeysoft page...
q.