eap file stored on MS Access?

[EA2412]

Hello everybody and thanks for your answers to my last question.

I´ve yet heared that there is a MS Access Database where the data of the eap-file is stored to. Is that right? Does anybody know which attributes are stored by default? I mean is there a sheet with all attributes which are stored at this database. The backround of my question is that I would like to implement a MySQL database to store the data but without any missing data. I mean I need all attributes which are important to display the hole data of the eap file into the database.  

Thanks a lot for your answers

[«Midnight»]

If I understand correctly what you are asking...

The EAP file is the MS Access database. You can verify this in a few ways (they are different ways of going about the same thing). First make a copy of an EAP file, since Access likes to convert the structure and this can be a one-way proposition.

You can rename the file to have an MDB extension, then open it with MS Access.

You can right-click an EAP file and use Open With to use MS Access. Don't choose Access as the default if you want EA to start by default if you double click an EAP file later. Windows will likely remember MS Access and offer it as a choice next time you follow this procedure.

You can start MS Access and use the File | Open dialog to open an MDB file.

Note that the default format is MS Access 97. The MS Access 2000 format might work OK if you have set the Jet 4.0 option. You can also download a Jet 4.0 base project from the Sparx site. [Just make sure you see all the features you expect; sometimes that file gets a bit out of date.]

HTH, David

[Dermot]

"I mean is there a sheet with all attributes which are stored at this database. The backround of my question is that I would like to implement a MySQL database to store the data but without any missing data."
- Transfering from a Eap to a DBMS is a feature suppoted in EA: Tools | Data Management | Project Transfer  - this will simplify the process for you.

[ Just a tip for David - the .eap file can be opened in MsAccess without changing the name - File | Open - set the listing to *.eap.  Given it is jet 3.5 it does come up with a message that things can't be modified - Data can updated - structure can't - best that it is not modified anyway]

[«Midnight»]

Yes, it does ask about the conversion. But the way the dialog reads in some versions of Access it is quite easy to invoke the conversion. While this usually makes a copy - and should preserve your data - it can be a real pain.