Any workstation on a network that connects to the database on another computer needs to have full read/write permissions to the Windows Registry key used by Camelot. This is so that when the program opens, it will be able to access that registry key to see where it needs to connect to the database files over the network.
To give full permissions for that user,
- login as Administrator user on the workstation
- go to windows Start > Run, type "regedt32", click OK
- Under HKEY_LOCAL_MACHINE, double-click Software, then highlight Vanguard Computer Systems, Inc.
- From the Security pull-down menu, choose Permissions (this is in Windows 2000, may be located elsewhere in other versions of windows, but should be basically the same screen)
- Choose to allow full permissions for Read and Full Control for all users
- Restart the computer, and login as the user in question, and again follow the above steps.
Another way to address this issue is to use command line parameters in the shortcut that opens Camelot to tell it where the shared database files reside. To do this, right-click on the Camelot shortcut icon on the desktop after installing, choose Properties, and on the Shortcut tab, in the Target box, make it read in the following format:
"C:\Program Files\Camelot\Camelot.exe" /db "F:\Program Files\Camelot\Database\Data.mdb" /wrkgrp "F:\Program Files\Camelot\Database\WrkGrp.mdw" /zipcodedb "F:\Program Files\Camelot\ZipCodes.mdb"
Where the first path is the path on the local computer to the Camelot program (C:\Program Files\Camelot\Camelot.exe), and then F: is the drive letter that is mapped to the drive on the server where Camelot is installed.
permissions new user non-admin user administrator login registry new windows user
Add to favorites