Sometimes Windows File Sharing seems to get itself in a mess and stops allowing full access to one or more of your database files.
Some users have observed this happen after restoring a database from a backup, or sometimes after performing a database integrity check. It also seems that this problem occurs more on Windows XP machines which don't have SP2 (Service Pack 2) installed.
Symptoms of the File Sharing going AWOL include (but are not limited to) :-
- ClinicOffice reports "Windows has denied access" errors on network computers (but not on the server)
- Your network appears to be working, but ClinicOffice says it "cannot find a valid clinic database"
- Windows reports that the "network resource is not accessible" when you know full well that it is!
This FAQ describes how to reset the File Sharing on your database folder.
Firstly, make sure that ClinicOffice is closed down on all computers, then do the following from your server computer.
[1] Disable the Sharing on the Database Folder
1. Locate your database folder (start by double-clicking My Computer)
2. Right click on it, then click Sharing and Security
3. Make a careful note of the "share name" on this screen
4. Untick the box which says Share this folder on the network
5. Click OK (you should see the 'hand' icon on your database folder has now dissappeared, indicating that the folder is no longer shared)
[2] Create a Copy of the Folder
1. Make a note of the folder name as we're about to change it
2. Click once on the folder to select it, then press F2
3. Type in a new name for the folder (e.g. if it was "ClinicDB" you could rename it to "ClinicDB.old") and press Enter
4. Right click the folder and click Copy
5. Click the Edit menu (at the top) and click Paste (you should now see something like "Copy of ClinicDB.old" appear as a new folder - you may need to scroll down to see it)
6. Click once on this new folder to select it, then press F2
7. Rename the new folder to whatever the original folder was called before you renamed it
[3] Re-instate File Sharing on the New Folder
1. Right click on the new folder which you have just renamed
2. Click Sharing and Security
3. Tick the box which says Share this folder on the network
4. Enter the share name that you noted down from earlier
5. Tick the box which says Allow network users to change my files
6. Click OK
You should see a 'hand' icon appear on your database folder which indicates that it is now being shared.
Phew! Just to recap what we've done :-
- Disabled sharing on the original folder
- Renamed the original folder
- Created a copy of the original folder
- Renamed the new copy to the whatever the original one was called
- Re-instated the sharing on the new folder
Now, you may be wondering why the need to do all this copying and renaming? Isn't it enough just to disable the sharing and then re-instate it on the same folder?
Apparently not . If the file sharing locks are in a mess, then simply disabling/enabling the sharing won't solve the problem.
If you find that problems persist after having taken the above steps, then it may be that there's a problem with your database (try running a database integrity check) but it's more likely that there is some other networking problem.
Here are a couple of 3rd party articles which may prove helpful in troubleshooting network faults :-
Microsoft Knowledgebase article
http://support.microsoft.com/default.aspx?scid=kb;en-us;304040
About.com article
http://compnetworking.about.com/od/windowsnetworking/tp/winfilesharing.htm
One final thought : ClinicOffice 2005 Client/Server edition doesn't use Windows File Sharing at all, so it may be worthwhile considering Client/Server if you're afflicted with file sharing woes.
_________________
ClinicOffice Support Team
|