Tag: ms-access

odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

I have some problem in PHP using MS Access database, when I running the query in PHP show error odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect But when I’m going echo the “$query” variable and running the sy…

Automate data flow from MS Access to MySQL

ms-access mysql pdo php vba

I need to automate a data flow from MS-Access to MySQL for an insurance company. Users will continue to work in MS-Access, but the changes done through the Access forms should take effect in MySQL as …

PDO connect to .accdb on network

ms-access pdo php

I have an access database which I would like to CRUD with PDO. When My database is stored on C:\wamp\www\test.accdb I can connect. However, the database I am interested in is stored on our office server, at \server1abc123test.accdb . server1 is mapped to drive z: on my computer. My code looks like this (verba…