MS Access cope with large files?

[tracyberge]

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?

[Geert Bellekens]

We are 2024, 20 MB is a small file.

Geert

[MichPaule]

Our .qeax files are around 120 MB and growing 

[qwerty]

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.

[Paolo F Cantoni]

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