Slow Access via LAN and windows 10 (1 Viewer)

[vagman]

Another problem showed up

MS Access 2000 on Windows 10 suddenly crashing anytime I try to add a listbox or combo box on a new form. - Microsoft Q&A

Have been using MS Access 2000 on my Windows 10 computer without problems since windows 10 came out. Suddenly started having issue with existing database crashing and startup form failing to load (believed to have started after April 13, 2023 windows…

learn.microsoft.com

 

[arjanbellyz]

I think that the problem is when 2 users with Win 10 are working in the same time in the same form

 

[The_Doc_Man]

After reviewing the entire thread, I see there is a significant question that was never asked. I'm not ashamed to ask questions for clarification.

What are the distribution characteristics of this database? I saw mention of a front end and that implies a back end. But does every user have a private copy of the front end?

 

[vagman]

After reviewing the entire thread, I see there is a significant question that was never asked. I'm not ashamed to ask questions for clarification.

What are the distribution characteristics of this database? I saw mention of a front end and that implies a back end. But does every user have a private copy of the front end?

Sorry for late reply and Happy new year !

Yes every user have a private copy of the front end

All problems solved now
On server I put new ssd disk and windows 7 pro
Users have win10

If users updated win10 we have crash on openning forms of Access 2000
The solution was to add the (Access 2000) msaccess.exe as an exception in the Data Execution Prevention (DEP).

Also I used the following for no hangs up :
Set these registry keys on the server: (Please look them up and check before putting these in place, don't blindly trust people who tell you to edit your registry! Including me!)

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters]
"EnableOplocks"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MRxSmb\Parameters]
"Oplocksdisabled"=dword:00000001

And this key on the client:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MRxSmb\Parameters]
"Oplocksdisabled"=dword:00000001