Charles, The specific error message would be helpful.
Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Charles F. McKnight [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 13, 2001 4:21 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] 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 > [EMAIL PROTECTED] ICQ: 2794793 | certainty is absurd. > [EMAIL PROTECTED] PGP: 0x20A5BCE5 | > - Voltaire > --------------------[ http://chucksays.mywebsitesucks.com > ]--------------------- > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]