I need to know if there is any way to connect PHP on RH Linux to Access on MS 2000. I am writing an application (PHP with a Postgres backend) to replace a Cold Fusion/Access app. The plan is to implement the application in stages, whereas data entry will begin using the new system (PHP/Postgres) while Cold Fusion handles the rest. Now, data entry functions in Cold Fusion will be disabled, but I still need to update the Access database (it's tricky, I know, but kinda cool).
My initial plan is to link a table on the Postgres db to the Access database which I will populate from the PHP app. I will then write an Access query that basically moves this data into the main table. (The CF app is pretty flat and there is NO way I can link this table instead). The only way I can think of to run the Access query is to create a Cold Fusion page that only runs this query when it is requested. I plan to request it from within the PHP script.
Does that make sense? Has anyone else had this problem, or have a better solution? I'm all ears...
My initial plan is to link a table on the Postgres db to the Access database which I will populate from the PHP app. I will then write an Access query that basically moves this data into the main table. (The CF app is pretty flat and there is NO way I can link this table instead). The only way I can think of to run the Access query is to create a Cold Fusion page that only runs this query when it is requested. I plan to request it from within the PHP script.
Does that make sense? Has anyone else had this problem, or have a better solution? I'm all ears...