ODBC with MS Access DB

I am writing a simple application that will store data in an Access database. I have gotten a simple script that connects and selects some data from the database and this works fine. when I try to insert or update data it fails. I assume I am missing some permissions or something to make it be readonly when I connect but the following is the relevant code in case it lies there: $db=odbc_connect('test', 'test', 'test') $query="INSERT INTO test (firstname) VALUES('Charles')"; $result=odbc_exec( $db, $query); As you can see it is about as simple as I can make it for a test so if someone could point me in the right direction to get this up and running I would greatly appreciate it. Thanks in advance, Charles -- Charles F. McKnight IRC: sokudo | Doubt is not a pleasant condition, but cfm@myemailsucks.com ICQ: 2794793 | certainty is absurd. cfmck@usa.com PGP: 0x20A5BCE5 | - Voltaire --------------------[ http://chucksays.mywebsitesucks.com ]---------------------