How do I ignore reserved characters in an VB-SQL statement?

[nemsshred]

I am developing a database bridge between the Act! contact manager and an Access database using the Act! SDK. I am using VB 6.0 as the front end and am having all sorts of trouble with Act!'s unique id field. I want to use Act!'s unique id field as the link between the master records in Act! and the child records in my database. At this time, I am unable to run SQL commands on the unique id field because of some of the characters it contains. Here are some example unique id's stored in Act!:

/)"($ WA/5^
T'TC# @)!N]

Note the presence of the double quote in the first id and the single quote in the second id. These wacky ids are raising cain with my SQL statements. Basically, I want the program to treat all of the id's characters as one literal string so I can compare it to the ids stored in my database. Any suggestions for completing this task would be greatly appreciated.

Alex
NEMS

 

[Storyteller]

Hello nemsshred,

I don't have a specific answer for you. . .

I am working on a similar project. However, instead of using the ACT! SDK (as useful as it is) I am using ACTAccess as my conduit between ACT! and Access.

Check it out at

http://www.photoact.net/actaccess/

Hope this helps.

Michael