Answer
This issue occurs because the script doesn't have access to parent paths. In IIS 6 (in windows 2003 servers) this security setting is enabled by default.
If you have access to the server, you can change this in the IIS setup:
- Open IIS Manager, right click and choose properties on your virtual directory or website root of CactuShop.
- Click the Home Directory or Virtual Directory tab and click 'Configuration'.
- Click the Options tab and check the "Enable parent paths" setting is enabled.
If you do not have admin access to the server, and your host will not change these settings, you can do the following:
- Ask the host the full path to the directory where your Access database is. It should be something like C:/inetpub/wwwroot/mysite/data/cactushop6.mdb
- In the config.asp, enter this path for the strPathToDatabase setting
- In the strDataSourceName line, remove the 'server.mappath' part.
This should then map directly to the file rather than resolving the path dynamically. One side effect is that the back end 'backup database' and 'compact database' functions may not work, meaning you would need to use FTP to accomplish these maintenance tasks.