Im writing a DB application with ADODB Reference, but the problem im having is that i have a description field in my app wich allows people to enter symbols etc etc like Square brackets or ' and stuff like that, however when executing the sql command it throws errors like "Syntax Incorrect" etc etc.

What i was wondering is, Is there any way to Change the Relevant symbols when inserting into the database and Revert the symbols when Selecting DB records.

I have a very long way around it i wont post it as im too ashamed :P and it is resource intensive aswell basically checking for each of the symbols and changing them appropriatly. However this is no good as my DB is getting quite large and it is processing multiple description fields per second so its causing my App to hang while it loads the information. Even DoEvents doesnt prove much help.

Any help is greatly appreciated.

Devon