Extract .MDB

[Manu]

Hello,

I want to know if it's possible to extract the .mdb file that is generated in background when a project is opened.

Thanks.

[Tom G]

Hey,

Don't know what you exactly mean with extracting the mdb file, but I do know that you can simply change the EAP file extension to MDB and open the repository in MS Access.

Kr,
TG

[«Midnight»]

Though a safer route would be to change the extension of a copy of the file.

This will work to an extent. If you need to make any changes, MS Access will need to convert the file. You will then need to same the file in the prior format.

EA uses Jet 3.51 by default. This is equivalent to the MS Access 97 format. You can also set EA to use Jet 4.0 from the Tools | Options dialog. Once you exit EA and restart - you must do so for this change to take effect - EA will remember this setting. You are now using the MS Access 2000 format.

Note that you can connect to an EAP file via ODBC or OLEDB by specifying the appropriate version of Jet driver (or setting the 4.0 option in the case of OLEDB). If you use the corporate version of EA you can also connect to an EAP file is if it were a repository. Just create a data source as you would for a DBMS repository and go through the dialogs.

David

[Manu]

That is exactly what I was looking for

Thank you very much