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

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, then the second user opens the same access Database, then User #2 disconnects from it.Then the first user has very slow response and task manager on the Host PC, shows heavy network traffic.We are now unable to use our access DB with more than one remote user. Computers are a mix of Win 10 and 11. Worked fine until April updates.

:)

 

Recover access database

Looks like you will need to rebuild the whole thing but at least you have the data still, right?
EDIT: Wait did you try this?

Convert a database to the Access 2007 file format

http://office.microsoft.com/en-us/a...-the-access-2007-file-format-HA010048406.aspx


You cannot convert a replicated database to the Office Access 2007 file format. However, you can use Access 2007 to create a replica of a database that is formatted in either the Access 2000 or the Access 2002 - 2003 file format.


More copy and paste:
[paste:font size="5"]Convert an Access 97 database, Convert an Access 95 database, or Convert an Access 2.0 database.

• Click the Microsoft Office Button
  
  , point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.

• If any database objects are open when you use the Save Database As command, Access prompts you to close them prior to creating the copy. Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.

• In the Save As dialog box, type a file name in the File name box, and then click Save.

Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.

Here is a short and sweet version: http://www.ehow.com/how_7339817_convert-2003-database-access-2007.html

 

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.