Are Microsoft Access databases supported?


Yes, you can use one or more Microsoft Access databases in each IIS 8 webhosting package.
To do so, you should take following actions:
- Upload the database file (*.mdb or *.accdb) to your web space.
The simplest way is to use and FTP client.

- Create a “connection string” (your “connection string” contains all the required information to address your Access database).
This includes; connection method, location of the Microsoft Access database, username and your password.

- Here below you can find the different connection strings for you IIS 8 webhosting, depending on your Microsoft Access database version.


Microsoft Access 2003

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mydatabase.mdb;
Jet OLEDB:Database Password=MyDbPassword;


Microsoft Acess 2007

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myFoldermyAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;


Microsoft Access 2010

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myFoldermyAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;




Article Number: 2909
Posted: Fri, Sep 20, 2013 2:08 PM
Last Updated: Fri, Sep 20, 2013 2:08 PM
Posted: Nick Corne [nick.corne@hostbasket.com]

Online URL: https://onlinehelp.cloud.telenet.be/article.php?id=2909