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 syntax in Microsoft Access is running well. And this is my query: And
Tag: ms-access
Automate data flow from MS Access to MySQL
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
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 (verbatim) both of these give me error: