Accounting application struggles in Windows 10 (Mapped Network Drive)

Page 2 of 7 FirstFirst 1234 ... LastLast

  1. Posts : 29
    Windows 10
    Thread Starter
       #11

    Thank you so much on all your efforts. I will consider all that you said.

    Anyone else - if you have an idea how to solve the networking issue I am listening :)
      My Computer


  2. Posts : 11,318
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #12

    Keano,

    Just a final shot in the dark.

    Did the computer come with Norton?
    If so, have you removed it in favour of Windows defender?
    If so, do you run the Norton Removal Tool?

    I only ask because I once had similar symptoms when using the network to transfer large files to a computer that had once had Norton but on which I had not run the Norton Removal Tool after uninstalling it.
    - Network transfers of large files were either failing completely or were stalling mid-way.
    - I then ran the Norton Removal Tool and the symptoms disappeared.

    Denis
      My Computer


  3. Posts : 29
    Windows 10
    Thread Starter
       #13

    This was a clean installation, so I have installed ESET Internet Security that we use on all machines in the company.

    I have tried:

    - disabling ESET (protection, firewall)
    - adding folder and .exe exclusion in ESET
    - adding exception in Windows Firewall

    No results at all :/
      My Computer


  4. Posts : 11,318
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #14

    Keano16 said:
    ... Databases <50 MB are opened and saved very fast.
    Problem are databases bigger than 50 MB ...
    Have you tested copying, in both directions, 50MB+ files between the 'server' and the problem computers [outside of the accounting database, just any old 50MB+ files]?

    Denis
      My Computer


  5. Posts : 29
    Windows 10
    Thread Starter
       #15

    Thank you for the suggestion. I did...

    Transfer speed is stable around 105 MB/s.
      My Computer


  6. Posts : 11,170
    Windows / Linux : Arch Linux
       #16

    Hi there
    @Keano16

    Network speed isn't a problem in this case -- however it's probably your application -- as a Database Access is about the worst thing ever designed as a database -- especially for multi-users. Concurrent users on Access just about kill the wretched thing anyway.

    Your best bet probably on the W10 computers is if you have to use Access would be to upgrade your Ms Office installation to Office 2019 or take out an Office/365 subscription.

    Otherwise I'm not sure of the effort involved but you would be a lot better off if you could switch from ACCESS to the (Free) Mariadb or MySQL -- these are genuine multi-user databases and very very fast too. Using 15 year old applications in a modern Internet / Digital era with loads of e-commerce all around probably isn't the best idea. At 105 MB/s the network isn't a problem for the clients.

    BTW a decent MariaDB (or MySQL) database on the server setup could offload a lot of the processing to the client computers also causing even less contention on your network. The server processes the queries and retrieves the data which the client computers then manipulate into what they want to do with the data.

    Sometimes in a business it's time to just bite the bullet and invest !!!!!


    Cheers
    jimbo
      My Computer


  7. Posts : 29
    Windows 10
    Thread Starter
       #17

    You think it is worth to try to upgrade to Office 2019 for test? How would this help? Thanks for additional clarification.

    I agree with your statements regarding the program and technology. We are in 2020 and .Mdb is not good option. However at the moment this is not my decision and we cannot force this overnight.

    At the moment I must enable my colleagues to continue their work in present app.
      My Computer


  8. Posts : 11,170
    Windows / Linux : Arch Linux
       #18

    Keano16 said:
    You think it is worth to try to upgrade to Office 2019 for test? How would this help? Thanks for additional clarification.

    I agree with your statements regarding the program and technology. We are in 2020 and .Mdb is not good option. However at the moment this is not my decision and we cannot force this overnight.

    At the moment I must enable my colleagues to continue their work in present app.
    Hi there

    @Keano16
    I'm not sure if you can get Office 2019 as a trial -- however if running a business you could get it for say one PC and I'm sure in most countries cost of that software would be recaimable back as tax --your business is accountancy so you probably know about that stuff far more then me. !!!

    When testing access though you need to stress test it with at least another user - preferably one using the older system (the non W10 machine) which you say works better.

    I'm positive it's the application that's causing a problem.

    For instance just test say with filezilla on windows (Free BTW) retriving a large file (>5GB as a decent start) from the server. Note Test retrieving the file FROM the server -- don't logon to the server and send the file -- you need to ensure that the client has the proper network connection. (On the server if it's windows - enable open-ssh server it's free with optional apps in windows - ensure the openssh service is started and running) --if it's a Linux type of server then ensure openssh (free) is installed and service sshd is enabled and running.

    The other thing to be aware of is the quality of the HDD's on the Windows 10 machines -- these should be replaced with SSD's if they aren't already --that's a reasonably cheap investment and will improve things radically in any case. (Again probably reclaimable on business taxes !!!)

    Network speed is in no way the problem here -- it's almost certainly in the application but if you have slow HDD's then any amount of tinkering won't improve application execution time.

    Cheers
    jimbo
    Last edited by jimbo45; 14 Jul 2020 at 05:39. Reason: added test transfer FROM server not TO server
      My Computer


  9. Posts : 29
    Windows 10
    Thread Starter
       #19

    I will try to do the tests ASAP.

    p.s. Windows 10 machines have SSD's. Machines are brand new. On the bit older ones the same problem is present. It is not related to HDD/SSD on client.
      My Computer


  10. Posts : 11,318
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #20

    Keano16 said:
    On the bit older ones the same problem is present.
    Keano,

    I thought you said the older ones were fine?

    Denis
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 09:31.
Find Us




Windows 10 Forums