Forum Discussion

Stephan7754's avatar
Stephan7754
Copper Contributor
Jun 11, 2020

query

I have an access application that runs fine on my laptop but on my desktop it hangs up (unresponsive) when I query field that then should bring in all associated data.  It works on a number of computers, but not my main desktop.

 

Windows 10

Microsoft Office 365 Home

 

  • Stephan7754 

     

    Is the accdb located on the same computer (e.g. on a shared network folder, or on the laptop) and only opened from different computers?

    Do you have anti-virus software on the desktop computer than might be interfering?

     

    Anything else different? Windows 10 on both computers, MS Office versions the same?

    • Stephan7754's avatar
      Stephan7754
      Copper Contributor

      The file is stored in a one drive folder, so both computers access it from the same place...  In fact it was pushed to the one drive folder from the desktop and then later accessed it from the same folder on the Surface notebook.

       

      Both computers are using only Microsoft's anti-virus

       

      All versions are the same, all kept up to date.... 

      • George Hepworth's avatar
        George Hepworth
        Steel Contributor

        Stephan7754 

         

        "...The file is stored in a one drive folder,..."

         

        Just so you know, running accdbs which reside in a OneDrive folder is generally considered a high risk approach. You ought to look into a more standard shared location on your network.

         

        Also, it sounds like this is not a split accdb relational database application because you refer to "it" Another unsafe approach. Sharing of a single accdb (with both tables and interface objects in it) is another high risk practice that is regularly associated with corruption of data.

         

        I suggest you invest some time in learning more about standard ways to design and deploy relational database applications, which is done with the following general guidelines.

         

        Split the relational database application into two files, one containing ONLY the tables with your data and one containing the remaining interface and logic--forms, reports, queries and VBA. The data file, usually referred to as the "Back End", is stored in a shared folder on your LAN (and again, OneDrive is considered an unsafe location for Access relational database applications in production). The interface and logic file is usually referred to as the "Front End". COPIES of the Front End, or FE, are deployed onto each user's computer and linked to the Back End, or BE. That way the data is shared, but each user has their own copy of the interface. If something goes wrong in any one of those FEs, it doesn't interfere with others.

         

        It's hard to know if the sharing arrangement here is the root of your performance problem (two people using one single accdb on OneDrive), but I will venture to suggest it's quite possible and unsafe.

Resources