Forum Discussion

Matti_Haapaniemi's avatar
Matti_Haapaniemi
Copper Contributor
Oct 27, 2021

Access software size and users

Hi   We have in business and producion Access software. Simultaously users is max 30 and size about 200 to 400 mb. But system crash sometimes ( 2 times a day) and make backup copy. Is there way to ...
access
Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Oct 27, 2021

Hi Matti,

 

Some questions about your system:

  1. What files does your Access application consist of?
  2. Is the application split into frontend and backend file?
  3. Does each user have his own frontend file?
  4. Which file exactly is inflating?
  5. Are there any error messages before Access crashes?

Servus
Karl
*********
http://AccessDevCon.com
https://www.donkarl.com

Matti_Haapaniemi's avatar
Matti_Haapaniemi
Copper Contributor
Oct 27, 2021
Hi

1. One file in server Access 2019 contains 10 tables
One file in workstations contains 200 queries, 100 forms, 30 reports , 120 macros
2. Backend in server and frontend in workstations
3. One frontend
4, File in server is inflating (maybe one of reports is doing this)
5. No error. Just slowing and stop system. New backup file is coming to server.

Matti
  • isladogs's avatar
    isladogs
    MVP
    Oct 27, 2021

    Matti_Haapaniemi 

    I hope you mean one frontend for each user on their own workstation.

    Are you using a persistent connection to the BE file? If not, I would recommend it

     

    Does the frontend contain any tables e.g. 'temp' tables that are being written to on a regular basis?

    Is Compact On close enabled in the FE? If so, disable it

     

    One way you could test what happens before a crash is to test for available connections.

    See Available Connections - Mendip Data Systems

    If the number of available connections drops significantly, the FE will slow dramatically and then crash. If that is the cause, you can take remedial action to close objects when not in use

     

    • Matti_Haapaniemi's avatar
      Matti_Haapaniemi
      Copper Contributor
      Oct 28, 2021

      isladogs 

       

      Each user has own frontend.

      We have localnetwork 1 gb to server.

      All tables are in server not frontend.

      CompactOn Close disabled.

      But available connections is intresting. we have lot of queries and reports and users

      keep all open. 

      I try to test but error comes (form and report is copies9

       

       

      • isladogs's avatar
        isladogs
        MVP
        Oct 28, 2021
        That sounds like a missing reference issue.
        DAO is part of a standard reference library. For ACCDB files, you need the Microsoft Office xx.0 Access Database engine object library. For older MDB files, use the Microsoft DAO 3.6 Library.

        Once that is installed the code should then run successfully.
        You should soon notice why its a Good idea to close forms and reports when not in use as well as setting recorders to nothing when you finish using them.

Resources