I am going mental on trying to work out a way for us to use our Windows 2008 SBS Server as it was intended.
We use MYOB Retail Manager v11 (which uses a Microsoft Access 97 databases) and other Microsoft Access 2003 databases and use a combination of Windows 7 and Windows XP machines with the Windows 2008 server.
Also if we use MYOB Premier it is extremely slow and also has issues when stored on the Windows 2008 server.
Ever since we have upgraded the server from Windows 2003 SBS we cannot use file shares and successfully run MS Access Databases with any clients. If the files reside on a Windows XP machine everything works OK, but the server which is a HP Proliant ML350 with mirrored drives cannot be used as it was intended.
I have spent considerable time and tried to researched various sites and tried some of things found which include disabling NETBIOS over TCP v4, and turning off SMB2 but these do not seem to fix the problem, so I have reverted all changes back.
All other server functionality works fine, we can save and use other files without any other issues. I have checked network settings, I have installed the latest service packs on the server and still cannot work out why there are problems.
The error reported in both MYOB Retail Manager and also within other Microsoft Access products says "Disk or Network Error". I can copy files to the same locations, have tried being an Administrator and tried changing security and even used UNC Paths but I cannot work out where the issue is.
I am running out of ideas and would appreciate if anyone could assist me.