Connecting and making queries into the jet database of a eap file

[danillodomingos]

Hi, is it possible to connect to the jet database of a eap file? It is basically to query data (only select, no update or delete).

If it is possible, can we read these data into another application? I mean, is it binary or in a format that can be read?

Im trying to do this because my atempts of using script to generate documentation in EA 9 were frustrated by bugs and limitations in the script api.

Updating the version of EA isnt an option.

[Sunshine]

EAP file is just an MS Access data base so yes it is possible to open it with MS Access and run reports or queries.
In case you don't have MS Access you could also open with Libre Office too.Not sure why upgrading Sparx EA V9 isn't an option its inexpensive to do so. You could spend a lot of time and effort that translates into money so have a careful think about not upgrading. Sparx may have fixed those bugs you mentioned for a start. Personally I'd upgrade as V9 is pretty old now but you probably have your reasons.

There is a caveat with MS Access the original eap file uses Access 97 so later versions have to convert to Jet 4.0 to create queries. You can upgrade using Jet 4.0 option in the options dialog of Sparx EA and doing project transfer to the jet 4.0 eap. You have down load from Sparx Site the base for Jet 4.0 and replace the EA_Base.eap file in program files. Instructions can be found on sparx systems website.

[Geert Bellekens]

I use a free SQL tool called AnySQL Maestro to query .eap files.

Geert

[danillodomingos]

I use a free SQL tool called AnySQL Maestro to query .eap files.

thanks will try that