why won’t my PHP program update my ACCESS database on the Server?
September 26th, 2009 | 
Author: I am developing some PHP programs for a website. I’ve been developing locally on my laptop using Apache. Locally, I can access, insert, and modify the tables in my ACESS database.
When I uploaded everything to the server, I can still acess the database to get info, but when I try to insert or update different tables I get a NULL return from odbc_exec.
Does anyone have suggestions?
Just a suggestion but I would not try to use Access on a live server. MySql will way out perform it and its open source. Access only allows 5 connections at a time!
Posted in program in php
Make certain your user ID has the rights to insert and update.
References :
Don’t forget to create a ODBC DNS on your server (under the Control Panel). The ODBC configuration is "per computer", you have to set it up on each computer.
Also, make sure that the IIS (or Apache) user has Write access to the DB.
Then, make sure that your Access database is accessible from both locations. If you have 2 database, you’ll make them point to 2 different locations (but be careful when you program to make sure that any changes on your laptop DB is replicated to your server DB).
References :
Just a suggestion but I would not try to use Access on a live server. MySql will way out perform it and its open source. Access only allows 5 connections at a time!
References :