Please enable JavaScript to view this site.

Navigation: Advanced topics

Working with MS Access databases

Scroll Prev Next More

 

1. If you need to work with Microsoft Access databases, we suggest installing a 32-bit version of PHPRunner.

 

2. You also need to install the Microsoft Access Database Engine to be able to connect to your database. You need to install it on the local machine and the web server.

 

Download link. Choose 64-bit version:

 

Microsoft Access Database Engine

 

Install it. If it doesn't install (i.e., you see a warning related to the 64-bit Office components conflict), try running it from the command prompt with the "/passive" parameter:

 

AccessDatabaseEngine.exe /passive

 

If you are trying to install Microsoft Access Database Engine 2016 or a newer version, use the "/quiet" parameter:

 

AccessDatabaseEngine.exe /quiet

 

3. On the web server, make sure you have provided full permissions to web server users for the folder where the database file resides.

 

4. Make sure that your php.ini file contains the following line:

 

extension=php_com_dotnet.dll

 

See also:

Connecting to the database

Open Database Connectivity (ODBC)

 

Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software