MS Access Update error!

Results 1 to 3 of 3

Thread: MS Access Update error!

  1. #1
    Join Date
    Dec 1969

    Default MS Access Update error!

    I&#039;m trying to add records through a query rather than a table with a rs.addnew. I&#039;m getting this error. What do I need to do to this query to make it add records?<BR><BR><BR>[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

  2. #2
    Join Date
    Dec 1969

    Default RE: MS Access Update error!

    Depends on the query. If you have a query which joins two tables, you may have trouble updating the data. In a one-to-many join, updating the "many" side is impossible, because the database won&#039;t know which of the "many" records to update.<BR><BR>Hope this makes sense. If not, show us the query.<BR><BR>Oliver.

  3. #3
    Join Date
    Dec 1969

    Default (eop)


Posting Permissions

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