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?

__________________

---

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).

__________________

---