Knowledge Essentials - 3Essentials Hosting

Using ASP with an MS Access mdb file on IIS7 hosting

Article ID: 1568

 Back to Search

 

IIS7 still supports classic ASP, but a few changes in the execution model have changed the groundwork a bit for using ASP with an MS Access mdb database.  

First, as with IIS6 as well, we recommend you do NOT store your MS Access mdb file in the (ftproot)/httpdocs folder (or below).  It should instead be placed inside a directory in the (ftproot)/private folder, such as (ftproot)/private/database.  This is a security measure.
 

If you need to specify an absolute path to the file or you have recently been migrated from one server to another and need to update the path, please note the following:

Windows Shared hosting servers with Windows 2003 and IIS6. This includes web6, web8, web10, web12. The path to your hosting spacewould be:

e:\inetpub\vhosts\domain.com\httpdocs - this is your site's root directory

e:\inetpub\vhosts\domain.com\private - this is your private directory.

Windows Shared hosting servers with Windows 2012 and IIS8. This includes web36, web38, web40, web42, web44, web46, web48. The path to your hosting spacewould be:

p:\inetpub\vhosts\domain.com\httpdocs - this is your site's root directory

p:\inetpub\vhosts\domain.com\private - this is your private directory.

 

On Windows servers with Plesk 11.x or Plesk 12.x See the KB article below which explains how to set file and folder permissions.

http://knowledge.3essentials.com/web-hosting/article/2221/HOW-To-Edit-Folder-and-File-Permissions-in-Plesk-11-and-12.html

 

On Windows servers with Plesk 7.x, 8.x, or 9.x, we need to make a permissions change for you on the server side you can't make through the control panel.  So, please open a support request, reference this KB article, and indicate that you need the necessary permissions changes for ASP accessing an MS Access MDB file, and confirm the location and name of the file in question.  Here's a sample submission:

As noted in KB article 1568, I'm using classic ASP on your IIS7 based hosting, and need the necessary permissions changes to support accessing an MS Access mdb file, located at: (ftproot)/private/mydatabasefile.mdb
 

 
Downloads Associated With This Article
No downloads are currently associated with this article.