Documentation of an Access DB

[Felix23]

Hi@all,

is it possible to document an MS Access Database?

[sargasso]

Yes ..... and no.  Try to be a touch more specific.

bruce

[Felix23]

Ok. I'v got a MS Access Database and I'm looking for a way to export it to Enterprise Architect to documant this Database.
Is it possible?

[sargasso]

Refer to help contents "Data Modelling" and specifically, "Import Database Schema from ODBC"

hth
bruce

[«Midnight»]

Felix,

Please note that EA fails to properly handle Access GUID (Replication_ID) data type. I've mentioned this to Sparx on two occasions, with an explanation of how to distinguish this type from un unsized text field via DAO, ODBC and ADO but have not managed to get any traction.

Other than this flaw EA seems to do a good job with Access databases.

Remember that you will have to connect to the database as a Windows data source when you do the reverse engineering. Just follow the dialogs and you should be fine. The EA help has little on this, but that's because the dialogs and functionality is provided directly by Windows.

David

[sargasso]

Midnight,

with an explanation of how to distinguish this type from un unsized text field via DAO, ODBC and ADO but have not managed to get any traction.

Could you provide details of that here. AFAIK all these i/fs return the string rep rather than the actual binary.

bruce

[«Midnight»]

Bruce,

It's been a while, but I think I posted the whole thing in the forum here. Try searching - I'm the author.

David

[sargasso]

Hmmm,

The only one I found was http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=general;action=display;num=1138557908;start=2#2
which was exactly the same discussion.  

bruce

[«Midnight»]

I checked my email logs but found nothing on this. I'll see if I can find it anywhere else.

Otherwise I'll have to find the source material again, which shouldn't be too difficult. It's just a matter of time.