[Solved] PHP and MS Access
Posted: Mon Feb 08, 2010 4:42 pm
Hi
I am fond of Web Apps but bump !!
I've got a fingerprint machine which is linux that connect to a database by a simple win application. Now the application can only use ms access for their database -- I hate it so much, mssql will be much better -- since their win application not quiet correct on managing the attendance data. I decided to create one of my own but using web apps and of course PHP.
I had installed all the necessary tool and program to connect to Ms Access in LINUX using ODBC driver thru DSN Connection.
It success, no problem in connecting
no problem in SELECT query, it return result.
problem with UPDATE, INSERT, DELETE query. The query doesn't effect the Database , no error return even if it's a simple query like "UPDATE test SET name = 'wpsd' WHERE id = 1"
I read that MS Access have problem with permission, but I'm able to change the database from C# win Apps but not PHP.
And also read that you won't be able to update/insert/delete table that have relationship. So I try create a simple database with one table only, the table call test and have attribute id and name . Then I try use the simple query above, but no luck.
Any one have experience using LAMP and MS Access ? All the tutorial seems only show how using SELECT query
I am fond of Web Apps but bump !!
I've got a fingerprint machine which is linux that connect to a database by a simple win application. Now the application can only use ms access for their database -- I hate it so much, mssql will be much better -- since their win application not quiet correct on managing the attendance data. I decided to create one of my own but using web apps and of course PHP.
I had installed all the necessary tool and program to connect to Ms Access in LINUX using ODBC driver thru DSN Connection.
It success, no problem in connecting
no problem in SELECT query, it return result.
problem with UPDATE, INSERT, DELETE query. The query doesn't effect the Database , no error return even if it's a simple query like "UPDATE test SET name = 'wpsd' WHERE id = 1"
I read that MS Access have problem with permission, but I'm able to change the database from C# win Apps but not PHP.
And also read that you won't be able to update/insert/delete table that have relationship. So I try create a simple database with one table only, the table call test and have attribute id and name . Then I try use the simple query above, but no luck.
Any one have experience using LAMP and MS Access ? All the tutorial seems only show how using SELECT query