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.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mydatabase.mdb;
Jet OLEDB:Database Password=MyDbPassword;
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myFoldermyAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myFoldermyAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;