the DB in Access format (Ms Office 2000). Web server is IIS on Windows 2000 Advanced Server.
"ID" is not autonumber, but number (long integer).
  ----- Original Message ----- 
  From: Neil Lunn 
  To: dbi-users@[...].org ; haitrieu@[...].com 
  Sent: Friday, October 20, 2000 12:51 AM
  Subject: Fwd: Re: Couldn't write to Ms Access Database by DBD:ODBC



  What version of Acess and is "ID" an Autonumber.

  > From: "Neil Lunn" <corrosion99@[...].com>
  > Reply-To: corrosion@[...].to
  > To: haitrieu@[...].com, dbi-users@[...].org
  > Subject: Re: Couldn't write to Ms Access Database by DBD:ODBC
  > Date: Thu, 19 Oct 2000 12:33:31 EST
  > 
  > 
  >  >From: "Hai Trieu, Nguyen" <haitrieu@[...].com>
  >  >To: "Ilya Sterin" <ideas_pc@[...].com>, <dbi-users@[...].org>
  >  >Subject: Re: Couldn't write to Ms Access  Database by DBD:ODBC
  >  >Date: Thu, 19 Oct 2000 09:09:21 +0700
  >  >
  >  >This is a single table, you know this DB was for testing so i just made a
  >  >temp DB, so of course it has ony one table.
  > 
  > Can you read from the table ( ie select ) . My guess is no, which makes 
  > this
  > a permissions problem.
  > 
  >  >   Hi all!
  >  >   Can anyone tell me how to solve this problem:
  >  >   I tried updating the database in Ms Access format (.mdb) by using
  >  >DBD::ODBC
  >  >   (on IIS/ win2000). But i could only read (by SELECT) the data, could 
  > not
  >  >   write (by INSERT INTO, or UPDATE).
  >  >   When I trace DBI::errstr, it was :
  >  >   "[Microsoft][ODBC Microsoft Access Driver] Operation must use an
  >  >updateable
  >  >   query. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) "
  >  >
  >  >   I'm sure every read/write security was correctly set, some of my 
  > script
  >  >is:
  >  >
  >  >   use DBI;
  >  >   $dbh = DBI->connect("DBI:ODBC:Save", "admin","pass");
  >  >   $sql = "INSERT INTO Data (ID, Name) VALUES (3, 'Peter' )";
  >  >   $dbh->do($sql) or print "error = $DBI::errstr";
  >  >   $dbh->disconnect;
  >  >
  >  >   # Save is the DSN
  >  >
  >  >   I tried to replace DO command by PREPARE and EXECUTE but it generated
  >  >the
  >  >   same error.
  >  >   I'll preciate any suggestion.
  >  >   Thanks.
  >  >
  >  >
  >  >
  >  >------------------------------------------------------------------------------
  >  >   DBI HOME PAGE AND ARCHIVES:
  >  >http://www.symbolstone.org/technology/perl/DBI/
  >  >   To unsubscribe from this list, please visit:
  >  >   http://www.isc.org/dbi-lists.html
  >  >   If you are without web access, or if you are having trouble with the 
  > web
  >  >   page,
  >  >   please send mail to dbi-users-request@[...].org with the subject line 
  > of:
  >  >   'unsubscribe'.
  >  >
  >  >------------------------------------------------------------------------------
  >  >
  >  >
  >  >   ______________________________________________
  >  >   FREE Personalized Email at Mail.com
  >  >   Sign up at http://www.mail.com/?sr=signup
  >  >
  >  >
  >  >
  >  >
  >  >------------------------------------------------------------------------------
  >  >   DBI HOME PAGE AND ARCHIVES:
  >  >http://www.symbolstone.org/technology/perl/DBI/
  >  >   To unsubscribe from this list, please visit:
  >  >   http://www.isc.org/dbi-lists.html
  >  >   If you are without web access, or if you are having trouble with the 
  > web
  >  >   page,
  >  >   please send mail to dbi-users-request@[...].org with the subject line 
  > of:
  >  >   'unsubscribe'.
  >  >
  >  >------------------------------------------------------------------------------
  >  >
  >  >
  >  >   ______________________________________________
  >  >   FREE Personalized Email at Mail.com
  >  >   Sign up at http://www.mail.com/?sr=signup
  >  >
  >  >
  >  >
  >  >------------------------------------------------------------------------------
  >  >   DBI HOME PAGE AND ARCHIVES:
  >  >http://www.symbolstone.org/technology/perl/DBI/
  >  >   To unsubscribe from this list, please visit:
  >  >http://www.isc.org/dbi-lists.html
  >  >   If you are without web access, or if you are having trouble with the 
  > web
  >  >page,
  >  >   please send mail to dbi-users-request@[...].org with the subject line 
  > of:
  >  >   'unsubscribe'.
  >  >
  >  >------------------------------------------------------------------------------
  >  >
  >  >
  >  >
  >  >------------------------------------------------------------------------------
  >  >DBI HOME PAGE AND ARCHIVES: 
  > http://www.symbolstone.org/technology/perl/DBI/
  >  >To unsubscribe from this list, please visit:
  >  >http://www.isc.org/dbi-lists.html
  >  >If you are without web access, or if you are having trouble with the web
  >  >page,
  >  >please send mail to dbi-users-request@[...].org with the subject line of:
  >  >'unsubscribe'.
  >  >------------------------------------------------------------------------------
  >  >
  > 
  > _________________________________________________________________________
  > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
  > 
  > Share information about yourself, create your own public profile at
  > http://profiles.msn.com.
  > 
  > 
  > 
  > ------------------------------------------------------------------------------
  > DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
  > To unsubscribe from this list, please visit: 
  > http://www.isc.org/dbi-lists.html
  > If you are without web access, or if you are having trouble with the web 
  > page,
  > please send mail to dbi-users-request@[...].org with the subject line of:
  > 'unsubscribe'.
  > ------------------------------------------------------------------------------
  > 

  _________________________________________________________________________
  Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

  Share information about yourself, create your own public profile at 
  http://profiles.msn.com.



------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page, 
please send mail to dbi-users-request@[...].org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------