VB Forum / Database Access / February 2006

Hi...

We have a VB 6.0 application which has 128 forms, 6 modules, and 54
class modules in it. We are currently looking at moving from Access DB
as our back-end to SQL. Converting a database from Access to SQL is not
a big deal for us but the challenge which we face right now is, in VB
application, all our sql statements have date delimiter as "#" while in
SQL the date delimiter should be "'" (single quote). With this huge
project, keeping this change in mind, changing each and every delimiter
is a painful task. we can't look at find "#" and replace it with "'"
(single quote) as we need this application to be compatible with Access
as well as SQL. I was just wondering if we have an automated way to
make this application compatible with SQL rather than changing the date
delimiters in each and every form. Help on this one will be greatly
appreciated. Thank you.

Hetal.