Aposterphe in Access

Results 1 to 3 of 3

Thread: Aposterphe in Access

  1. #1
    Join Date
    Dec 1969

    Default Aposterphe in Access

    Hello,<BR>I am wondering about....Yep the apostorphe question. How do I fix it so I can add apostorphes in my forms and still insert them into a DB. <BR><BR>YES I have read the FAQ and I do realize why the DB is not accepting because it thinks my SQL statement is being cut. I couldnt understand the explanation they gave to fix it. <BR><BR>Someone please help and put it in simple terms. Ive tried everything.<BR>Thanks SOOO much

  2. #2
    Join Date
    Dec 1969

    Default RE: Aposterphe in Access

    Post your code

  3. #3
    peterjl@austec.net.au Guest

    Default RE: Aposterphe in Access

    Use the recordset.AddNew method instead of the Connection.Execute method, and you won&#039t have this problem. AddNew is slightly less efficient, but for code readability and maintenance, it is much easier. <BR><BR>If you are generating SQL commands to do your updates, you will need to replace all convert all &#039 to &#039&#039 and all " to "".

Posting Permissions

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