Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: tracyberge on April 12, 2024, 02:53:32 pm

Title: MS Access cope with large files?
Post by: tracyberge on April 12, 2024, 02:53:32 pm

The model for the project I'm working on is rapidly increasing in size, it is up to 7MB now. Closer to the end of the project, the model may occupy 15-20MB, according to our estimates. Do you have any idea whether the model size can be an issue for us?

Title: Re: MS Access cope with large files?
Post by: Geert Bellekens on April 12, 2024, 03:18:17 pm

We are 2024, 20 MB is a small file.

Geert

Title: Re: MS Access cope with large files?
Post by: MichPaule on April 12, 2024, 06:18:07 pm

Our .qeax files are around 120 MB and growing  8)

Title: Re: MS Access cope with large files?
Post by: qwerty on April 12, 2024, 06:50:53 pm

eap is M$Access. Now and then you have to manually compress it (removing dead entries). EA has a manage DB option somewhere to do that. Better option: get rid of it and use a "real" DB.

q.

Title: Re: MS Access cope with large files?
Post by: Paolo F Cantoni on April 13, 2024, 10:15:15 am

Quote from: tracyberge on April 12, 2024, 02:53:32 pm

The model for the project I'm working on is rapidly increasing in size, it is up to 7MB now. Closer to the end of the project, the model may occupy 15-20MB, according to our estimates. Do you have any idea whether the model size can be an issue for us?

We regularly used to use 2GB MS Access files (.eapx), usually as snapshots of our main Sever repositories (created using Project Transfer).  Now, unfortunately our snapshots have exceeded 2GB (the maximum file size MS Access can handle as a repository).  So we've had to switch to .qea snapshots.

You have NOTHING to worry about from a sizing perspective.

Paolo