Update And Delete Rows in Access Database Using Php

[courtyard]

Can any one help me how to update and delete rows in the MS ACCESS database using PHP.

[eelixduppy]

Welcome to WebmasterWorld!

You are going to need to use the ODBC Functions [us.php.net].

There aren't many people around here that use access with their php apps, however there are some great tutorials online. Try a Google Search [google.com] to see if anything comes up. I know phpfreaks has a nice one.

[joelgreen]

Yes, you will have to setup ODBC data source.

After data source is setup you'll have to use
- native odbc php functions to query Access
or
- Pear Db (pear.php.net/DB) or Adodb (adodb.sourceforge.net) libraries. These libraries designed to abstract from database. If correctly utilized changing DBMS is as easy as changing one line of code.