Dreamweaver: Database Permissions Problems for Access Databases

You may find that Dreamweaver has trouble accessing the Access database (in this case it's called a "No-Access" database, ha, ha). The problem is usually related to permission problems: that is, Dreamweaver doesn't have permission to read the database. The process for fixing this problem varies depending on which operating system the Web server is running on, Win 2000 or Win XP.

If you continue to have problems with the tutorial, you should try the PHP version of the tutorial. It runs on both Windows and Macintosh and is nearly identical (apart from the underlying server technologies) to the one in the book. You can download the PHP/MySQL tutorial here.

Solution for Win 2000

visit: http://www.webwizguide.info/asp/faq/server_permissions.asp

Solution for Win XP

1. Start->Control Panel
2. Double-click Folder Options
3. Click the View tab
4. Scroll to the bottom of the menu and uncheck “Use Simple File sharing.”
5. Click OK to apply and close window.
6. Locate the FOLDER containing the nationalEx.mdb Access database (the DWDynamic folder you downloaded.)
7. Right-click on the folder and choose Properties.
8. Click the Security tab, then click the Add button. This opens the Select Users and Groups window.
9. Click the Advanced button and click the Find Now button. This will generate a list of all users and groups on the computer.
10. Scroll down until you find a name that begins with IUSR_ and select it. (The last part should be the name of your computer, IUSR_MyComputer, for example.)
11. Click the OK button to select the IUSR_ user and click OK again to close the Select Users and Groups window. You are now back at the Properties window for the database file.
12. Select “Internet Guest User” from the list of group and user names.
13. Click the Full Control check box in the Allow column and click the Apply button. This gives IIS control over this file so that it can open, close and lock it for reading, editing and updating the file.
14. Restart your computer
15. Restart Dreamweaver and continue with the tutorial.