Microsoft Access databases

Microsoft Access Databases can be placed on our Windows 2000 servers for use with your ASP pages.

Uploading Your Database
You should upload your database file created with Microsoft Access to the /private directory within your web space, your database file should have the extension .mdb. Uploading your database to the /private folder allows your scripts to access the data within it without allowing internet users to download your entire database file and given the special file permissions on the /private folder allows your scripts to write data to the database.

Connecting To Your Database
You should connect to your access database using a DSN less connection. You might use code such as the following:

'joebloggs' being your HOSTING account name and 'j' and 'o' the first and second characters of your HOSTING account name. Note that when your account is accessed via the SSL secure server, the full path is different, see the SSL page for more information

DSN less connections are faster and more efficient than ODBC connections since they avoid the need for a registry lookup, for this reason, ODBC connections for Access databases are not supported.