Results 1 to 4 of 4
  1. #1
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155

    Regarding Acess Capability

    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?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    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...

  4. #4
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by ridders52 View Post
    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!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Bar Graph on Form with Drill Down Capability
    By EddieN1 in forum Programming
    Replies: 3
    Last Post: 07-24-2016, 08:35 AM
  2. Help with Access capability
    By behamout in forum Access
    Replies: 3
    Last Post: 06-07-2016, 11:46 PM
  3. Replies: 1
    Last Post: 03-04-2015, 12:39 PM
  4. Drill Down capability
    By Eric@Gopher in forum Access
    Replies: 3
    Last Post: 08-07-2012, 01:01 PM
  5. Auto Fill-In Capability?
    By bbarrene in forum Access
    Replies: 3
    Last Post: 01-15-2010, 08:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums