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;


Aangemaakt door : - Fri, Sep 20, 2013 2:08 PM. Dit artikel werd 2607 keer bekeken.
Online URL: https://onlinehelp.cloud.telenet.be/article.php?id=2909

Powered by PHPKB (Knowledge Base Software)