Can I connect to microsoft Access from PHP and how do I do so?
sure you can ... simply use an ocbc-connection.
checkt out this man-page: http://www.php.net/manual/ref.odbc.php
regards finger
Or take a look at this column: http://www.phpbuilder.com/columns/siddarth20000228.php3
If you have more questions, feel free to ask.
Step by Step
1.- Install PHP for Windows 2.- Create ODBC connection (system DSN or user DSN, ponting to your Ms Access Database). 3.- Create the PHP script to using the ODBC functions from PHP.
Can I define the MDB on the fly instead of select the MDB in ODBC?
Thanks for all of the advice, it was very helpful. I'm trying to transfer over from ASP and it's a little trying!
I think so, but I haven't tried it myself. In the responses to Siddarth's MS Access column, look through the questions regarding a DSN-less connection.
i am trying to connect a MS Access database file to Generator 'List' object. i am getting an error saying that 'Clip column not found in data source'. Could anybody write me how i can solve this problem.
