API to compact a .EAP file.

[Paolo F Cantoni]

A quick search of the forum suggests there is not an API call to directly compact a repository from EA.

I couldn't find one in the Help system.

Is that correct?

Paolo

[qwerty]

I'd guess so. But that's Mickeysoft functionality. There might exist official APIs to compact an Access file.

q.

[Paolo F Cantoni]

I'd guess so. But that's Mickeysoft functionality. There might exist official APIs to compact an Access file.

q.

Yes, I can do it by spawning a subprocess to use Access to compact (we already spawn ZIP to create a compressed archive), but it's a lot of work for functionality that's already in already in EA - just not accessible (pun intended).

Paolo

[Glassboy]

Yes, I can do it by spawning a subprocess to use Access to compact (we already spawn ZIP to create a compressed archive), but it's a lot of work for functionality that's already in already in EA - just not accessible (pun intended).

My assumption would be that it isn't in EA at all, but EA calls the API for the data layer.  The method might be called something like JetCompact for example.

[qwerty]

Most likely. But of course it would be more convenient if the AP could provide the manual methods in its API.

q.

[Eamonn John Casey]

To do this you need to rename the local EAP file to MDB (Microsoft Access Database).

In under ODBC Data Sources (Start -> ODBC), select Microsoft Access as the your User Data Source. Click on the Select button to find your database¨. Then click on the Compact button. Job done.

Rename MDB back to EAP so Enterprise Architect can find it.

Eamonn J.

[Eamonn John Casey]

Amend:
ADO and DAO APIs for Microsoft access provide compact functionality if you want to do this programmatically.
For example: http://stackoverflow.com/questions/3503736/access-compact-and-repair-programatically