Question: I'm facing error message below when try to backup Xin Inventory 2.0 database
Cannot open backup device 'C:\Program Files (x86)\Xin\Xin Inventory 2.0\XinBackup\XinInventory.bak'. Operating system error 5 (Access is Denied.).
BACKUP DATABASE is terminating abnormally.
We suggest you restart Xin Inventory.
Answer: This error is caused by the folder permission setting. To solve this issue, there are 2 thing that need to set.
- Share Xin Inventory 2.0 installed folder
- Set permission for Everyone (Modify permission)
Share Xin Inventory 2.0 installed folder
After installation, share Xin Inventory 2.0 folder to the network user with read and write permission. By default, the installation folder in 32 bit machine is "C:\Program Files\Xin\Xin Inventory 2.0" and for 64 bit machine is "C:\Program Files (x86)\Xin\Xin Inventory 2.0".
1. Right click on Xin Inventory 2.0 folder.
2. Then click on Properties.
3. Click on Sharing Tab
4. Click on Advanced Sharing button.
5. In the Advanced Sharing window, checked on Share this folder.
6. Click on Permission button.
7. In the Permission for Xin Inventory 2.o window, check on Allow Change checkedbox.
8. Click on OK button.
Set permission for Everyone (Modify permission)
Go to Xin Inventory 2.0 folder. By default, the installation folder in 32 bit machine is "C:\Program Files\Xin\Xin Inventory 2.0" and for 64 bit machine is "C:\Program Files (x86)\Xin\Xin Inventory 2.0".
1. Right click on Xin Inventory 2.0 folder.
2. Then click on Properties.
3. Select Security tab
4. Click on Edit button
5. In the Permissions for Xin Inventory 2.0 window, click on Add button.
6. Type everyone in the Select Users or Groups window
7. Click on Check Names button.
8. Click on OK button.
9. In the Permissions for Xin Inventory 2.0 window, select Everyone.
10. Check on Allow Modify check box.
11. Click on OK button.
Please try again after this setting.