I received this question from someone a little while back concerning Access freezing on them whenever they tried to open their database over a network that was stored on a Vista machine. I couldn't come up with a solution for them, but they ended up finding something interesting on the Microsoft web site. Read on for details...
QUESTION:
I installed a new pc(Vista) beacause my old one(XP)crashed. I have this access application that worked perfectly before with the program *.mde stored locally(c:) and the database stored on a fileserver (*.mdb)
I can open the program with no problem at all. Once i try to open a table/form it opens but freezes(not responding) see the first fields but can't doe anything further.
I tried Access 2003 and 2007. Still the same.
Any idea what this could be ?
ANSWER:
I've never experienced this problem before. A few things to try:
- Mapped network drive (F:) versus UNC paths (\\server\F)
- Compact and repair your database
- Try it without using an MDE file
- Try pulling your two database files back together into one and see if that helps
- Check for updates (Windows, Office, etc.)
FOLLOW-UP
i found the sollution for this problem on a microsoft forum and wanted to share it with you:
This appears to be a problem with the new SMB2 protocol developed for Windows Vista. For a brief description of what SMB2 is, See: http://wiki.ethereal.com/SMB2
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.
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 unkown if disabling SMB2 will have any other side-effects. To disable SMB2 on the machine hosting the shared folder, add a registery 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.
18 years ago
