
May 12th, 2003, 12:21 PM
|
|
Junior Member
|
|
Join Date: Jan 2003
Posts: 24
Time spent in forums: 7 sec
Reputation Power: 0
|
|
|
I already tried using replace(str, "'", "\'")
However, when I use this, and I try to Update the information in the database, I get the following error:
Microsoft JET Database Engine (0x80040E14)
In operator without () in query expression ''1. \' In '.
I tried replacing the \' with other characters, and those work fine, however the value in the database is then incorrect. I also tried putting "\" & chr(39) for the last parameter of the replace function, however, this didn't work properly either.
|