This appears to be a problem with the new SMB2 protocol developed for Windows Vista.
This problem actually will occur when sharing any file (not just a database) between two Vista computers.
Disabling SMB2 on the machine that hosts the share seems to solve the problem. Share works fine when a Windows XP machine hosts the shared folder because XP does not support SMB2 and the machines connecting will use SMB.
Two options are available:
This is a Microsoft Hotfix, you must call Microsoft and charges may apply.
Fix #2: Apply this change at your own risk!
So far this is an undocumented problem only known by Microsoft's internal support staff, so use this information at your own risk. It is unknown if disabling SMB2 will have any other side-effects. To disable SMB2 on the machine hosting the shared folder, add a registry value named SMB2 under HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSET/SERVICES/LANMANSERVER/PARAMETERS and set it to 0. Reboot.
We are recommending that our clients set up an XP machine to host the share until the problem is addressed in a real MS Knowledgebase article with proven results or until a fix is provided in a normal Microsoft Service Pack.
Below is a copy of the final response from MS Technical Support to Design Manager concerning the issue:
It was my pleasure to assist you during your "Problems using Access database shared between VISTA" issue. I hope that you were delighted with the service provided to you. I am providing you with a summary of the key points of the case for your records. If you have any questions please feel free to call me. You can reach
me using the contact information below and referencing the case ID.
PROBLEM: * Problems using Access database shared between VISTA
RESOLUTION: * We made a new DWORD(32bit) "SMB2" under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
* Rebooted the machine and got everything is working fine.
Again thanks for your time and patience in this matter.
Based on our last conversation, I am closing your case SRX070306603360. If your issue has recurred or you are not satisfied with any aspect of this case, please let me know as soon as possible. Thank you for choosing Microsoft.
Durgesh Kumar Singh
Support Engineer - Networking Team
Microsoft Enterprise Platform Support
Working Hours: 1:00PM - 10:00PM PST M-F
Phone: 425-635-3106 Ext: 65466
Alternate Contact if I am not available are:
Manager: Nitin Manocha
Working Hours:11:00 AM - 8:00 PM EST M-F
Phone: 425-635-3106 Ext: 66295
Tech Lead: Vivek Dugar
Phone: 425-635-3106 Ext: 66332