Cannot open MS Access on a Novell network drive from a Windows 7 client PC
Posted on 2011-02-28
We have a single-server network running Novell OES Small Business Edition. Our client PCs are all XP (SP3) except for one recently-purchased Windows 7 machine. Our Sales order processing is done in a Microsoft Access database, with the program installed locally on the PCs but the database on a mapped network drive. The database is split into a front and back end. It's in .mdb rather than the new .accdb format, as the client PCs run a mix of Access 2000 and Access 2007.
All works fine in this setup with the XP clients, but we are unable to open the database using the W7 machine. When attempting to do so we get an error message saying 'Could Not Update; Currently Locked'. Clicking OK to this brings up the revolving circle that has replaced the hourglass in Windows 7, then after a few seconds the message reappears. After doping this 3-4 times the program freezes and has to be closed using Task Manager.
I'm guessing this is something to do with Windows 7 security controls, but disabling UAC doesn't seem to help.