The Database
Setting up the database on the server
Screen Shot 7g: Select the ODBC Driver
Screen Shot 7h: Enter values for your Datasource
Next, we will have to allow the Internet User configured on XP to access the florist.mdb file. Without this step, users on the web will not be able to register or add online orders as the default Internet user will not be able to write to the database. First, open Windows Explorer and navigate to 'My Computer'. Click on 'Folder Options' in the 'Tools' menu. A window should pop up. Click on the 'View' tab. Scroll to the bottom and clear the box next to 'Use Simple File Sharing (Recommended)'. Now, click on the 'Apply' button and close the window.
4
Screen Shot 7i: Set the Folder View
Now, navigate to the Inetpub\wwwroot\florist\info folder. Right click on the 'florist.mdb' file and open the properties window. Click on the 'Security' tab. Now, select 'Internet Guest Account' on the top window and check the Read & Execute, View Folder, Read, and Write boxes as illustrated in Screen Shot 7j. The database can now be modified by Internet users!
Screen Shot 7j: Set Database Permissions
