INSERT problems

Results 1 to 2 of 2

Thread: INSERT problems

  1. #1
    Join Date
    Dec 1969

    Default INSERT problems

    Can anyone shed some light on this error message ...<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <BR><BR>What is an updateable query? I am trying an SQL INSERT to an Access database, using a standard DSN, ODBC connection. I can read from the DB OK, but not write to it?<BR><BR>Any help appreciated.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: INSERT problems

    i have seen this on occasion when RI (referential integrity) or a constraint has been violated...that is, when i tried to assign a value to a field that only accepted for instance "Y", "N" and I attempted to assign "YES".<BR><BR><BR><BR>hope this helps. :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts