Accounting application struggles in Windows 10 (Mapped Network Drive)

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

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

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

Keano16 said:

On the bit older ones the same problem is present.

Keano,

I thought you said the older ones were fine?

Denis