We are using Access 2013 on a n/w 3 comps (2 desk tops & one laptop).the file size of the prog. has grown to 40644 KB. The prog. has now slowed down. Has Access reached its limit? What should be done?
We are using Access 2013 on a n/w 3 comps (2 desk tops & one laptop).the file size of the prog. has grown to 40644 KB. The prog. has now slowed down. Has Access reached its limit? What should be done?
No - the file size limit is 2GB though there are plenty of other issues that can cause the database to slow down
First try compacting.
Then look at your table designs & see whether they can be improved
Are the tables normalised
Are all fields used regularly in searches, sorts & filters indexed?
Indexing will dramatically speed up queries
Next is your code as efficient as it could be?
As it is a multi user setup, is the database split with the BE on the server & each user having their own copy of the FE on their own computer?
Beyond that, there are other things to consider
45M is not a problem. do you have tables with more then 1M records? or lots of column sorting.... slow link to back end table.... one can bog down the smaller PCs - it is not Access it is the power of the PC...
No - the file size limit is 2GB though there are plenty of other issues that can cause the database to slow down
First try compacting.
Then look at your table designs & see whether they can be improved
Are the tables normalised
Are all fields used regularly in searches, sorts & filters indexed?
Indexing will dramatically speed up queries
Next is your code as efficient as it could be?
As it is a multi user setup, is the database split with the BE on the server & each user having their own copy of the FE on their own computer?
Beyond that, there are other things to consider
Thanks for the advice. God bless you!