I'm using Win32::ODBC and trying to insert a record into an access database.
This is the error I'm getting. SQL failed. Error: [-3035] [1] [0] "[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query." and this is the code I'm using #Opening database if (!($db = new Win32::ODBC($DSN))){ print "Error connecting to $DSN\n"; print "Error: " . Win32::ODBC::Error() . "\n"; exit; } $SqlStatement = "INSERT INTO project (projectid,name,startdate,status) values ($projnum,'$fields{prjname}',$fields{startdate},$status)"; if ($db->Sql($SqlStatement)){ print "SQL failed.\n"; print "Error: " . $db->Error() . "\n"; $db->Close(); exit; } #Closing database $db->Close(); what is wrong with this code, it works great for doing queries.