Invalid Object Name 'selections'

Results 1 to 2 of 2

Thread: Invalid Object Name 'selections'

  1. #1
    Join Date
    Dec 1969

    Default Invalid Object Name 'selections'

    I am getting the above error sql statement is as below<BR><BR>Set Add = db.Execute("INSERT INTO selections(&#039;" + strName + "&#039;) Values(&#039;" + checkedInput + "&#039;)")<BR><BR>I want to enter the user info in his column, which is stored in &#039;strName&#039;<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default Some issues

    The columnname shall not be quoted.<BR><BR>db.Execute "INSERT INTO selections(" + strName + ") Values(&#039;" + checkedInput + "&#039;)",,128<BR><BR>Also, there is no need to return an (empty) recordset when doing an insert

Posting Permissions

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