<div>
Double up the single quotes inside the string.<br />
Easiest way is to write a function - <br />
Public Function QuoteString(Value as string) as string<br />
Quotestring = &nbsp;&quot;'&quot; &amp;&nbsp;Replace(Value, &quot;'&quot;, &quot;''&quot;) &amp;&nbsp;&quot;'&quot;<br />
End function
</div>


Double up the single quotes inside the string.
Easiest way is to write a function -
Public Function QuoteString(Value as string) as string
Quotestring =  "'" & Replace(Value, "'", "''") & "'"
End function

<div>
Paramaterize your sql statements rather then using adhoc queries. &nbsp;This will fix this issue as well as prevent sql injection hacking on your application.
</div>


Paramaterize your sql statements rather then using adhoc queries.  This will fix this issue as well as prevent sql injection hacking on your application.

<div>
That's great, thanks to all of you for your help. I used your syntax for the parameterised queries for INSERT and UPDATE statements and they worked perfectly. Thank you. 
</div>


That's great, thanks to all of you for your help. I used your syntax for the parameterised queries for INSERT and UPDATE statements and they worked perfectly. Thank you.

<div>
<div class="content wysiwyg-content">
Hi, <br />
I am trying to do a very simple program with a VB.net front end and an Access 2002 back end. I have a list of names and since I am in Ireland many of them have an apostrophe in them. The program has no problems with names like &quot;Sean Murphy&quot; but needless to say the OLEDBCommand gets a bit antsy when it's &quot;Sean O' Murphy&quot;. Is there anyway that I can get SQL to realise that the apostrophe is part of the string and to ignore it and treat it like an ordinary character? <br />

<pre><code id="code-5473">
</code></pre>
</div>
</div>


Hi, 
I am trying to do a very simple program with a VB.net front end and an Access 2002 back end. I have a list of names and since I am in Ireland many of them have an apostrophe in them. The program has no problems with names like "Sean Murphy" but needless to say the OLEDBCommand gets a bit antsy when it's "Sean O' Murphy". Is there anyway that I can get SQL to realise that the apostrophe is part of the string and to ignore it and treat it like an ordinary character? 

VB.net/SQL dealing with apostrophes in strings

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.