Windows 10: After April Updates, shared Access Database encounters extreme network traffic and gets...

After April Updates, shared Access Database encounters extreme network traffic and gets very slow.Scenario: 3 PCs, host PC with the MDB file shared. 1st User PC and Second User PCStrange behavior happens usually after the first user opens the database located on the Host PC, then the second user opens the same access Database, then disconnects from it.Then the first user has very slow response and task manager on the Host PC, shows heavy network traffic.Computers are a mix of Win 10 and 11. Worked fine until April updates.We are now unable to use our access DB with more than one remote user.

:)

 

Recover access database

Did you try this yet? http://support.microsoft.com/kb/283849

Run the Compact and Repair utility. To do so, follow these steps:

• If the database is open, close it.
• On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
• In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.
• In the Compact Database Into dialog box, enter a new file name, and then click Save.
  
  If the compact and repair does not succeed, you will receive a message stating so. This means the damage is so severe that it cannot be corrected.

 

Cannot access shared network drive


Personally, I wouldnt use Everyone. If anyone hacks into you, they have full access to everything and can demolish everything on your raid. I would rather set up accounts and access separately for each person. That way, I know who did all that damage. In the end with a little extra work, I feel more secure by using Authenticated Users.


If this helps.
step 1 create non-microsoft account and without email and address without admin rights
step 2 share a drive or folder to specific user account (if Everyone is listed, remove it)
step 3 set security > add Authenticated Users (if more than 1 account) or add specific users
step 3a remove Everyone from list
step 3b uncheck full control and write for all items listed except SYSTEM and Admin account.
step 4 right click Start > Computer Management > System Tools > Shared Folders > Shares ... to verify settings and change anything else. You can also see the number of connections to each share here.