VB .Net, an Access Database and Quotations

C

cpopham

Well-known member
Joined
Feb 18, 2004
Messages
273
I am building a small program and it will be using Access as the backend. The database has a field that contains quotations, such as those by presidents, etc. These quotes will be entered by a user and as such may contain quote marks ("), apostrophes (), commas (,), ampersands (&), and possibly any other special character that my come to mind. I know about the trouble Access has handling the single apostrophe and how you should handle it by replacing it with a double apostrophe, but will I run into any other problems either with the string variable in VB .Net or Access with the other possible charachters such as quotaion marks (") and ampersands (&) and if so, how is the best way to handle them, so that they will be in the database, but now cause any problems?

Thanks, Chester
 
Hi,
From my point of view the only time it will be problem is if you insert/update the database using string concatenations. If you use parameters inserts/updates will be so much easier.

IMHO
/Kejpa
 
Back
Top