Re: Error -2147217833


"dguilbault" <dguilbault@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9859E7F4-6B1C-4770-B565-B7F75E72B11E@xxxxxxxxxxxxxxxx
Bob,

Ok here is the code

sqlstr = "INSERT INTO tblBonusType35Temp9 "
sqlstr = sqlstr & "SELECT tblContractsTemp.* "
sqlstr = sqlstr & "From tblContractsTemp "
sqlstr = sqlstr & "WHERE (((tblContractsTemp.autKey) Is Not Null)) "
sqlstr = sqlstr & "ORDER BY tblContractsTemp.lngVersionNumber"

Why do you have an ORDER BY clause when you are INSERTing?
Not required.

Are you sure the table structures for tblContractsTemp and
tblBonusType35Temp9 are identical?

Stephen Howe


.

Relevant Pages

  • RE: Forcing a sequence in a table
    ... or some other scheme like max+1 when ... inserting new rows. ... Then use an Order By clause to sort ...
    (microsoft.public.access.tablesdbdesign)
  • Trying to get a specific symbol
    ... This is in regards to Symbols. ... When inserting the symbol for "section ... or numbered clause", it inserts as a box in MT extra and in Symbols. ... When I changed fonts in the document. ...
    (microsoft.public.mac.office.word)
  • Re: Error message attempting to Appending data to a table using co
    ... Your query doesn't make sense to me. ... You are inserting into and selecting from ... I would think you need a VALUES clause instead of a SELECT clause. ...
    (microsoft.public.access.forms)