Problem in inserting a row to MS-Access Table

Priya ramanan

Hi Everyone,

I am trying to insert a row into MS-Access table. The table contains the details of error (number and description) occured in the whole script. The query written for inserting a row is as follows.

strQuery = "Insert into ErrorLog values('& Err.Number & ",' " & Err.Description & " ')"

The problem is the Error description is like "The directory doesn't exists", in which a single quote is present (doesn't). Because of that the row is not getting inserted.

So can u please suggest mw how to overcome this issue.

Thanks in Advance
Regards
Priya ramanan

Dec 17 '07 #1

QVeen72

Hi ,

Try to use Replace Function :
Something like this :

strQuery = "Insert into ErrorLog values(" & Err.Number & ",' " & Replace(Err.Description, "'", "") & " ')"

Regards
Veena

Dec 17 '07 #2

Priya ramanan

Thanks Veena. Its working fine.

But to know more about the problem, i am asking you this.
Is there any other solution to solve this issue.

If so just let me know.

Thanks Again

regards
Priya ramanan

Dec 17 '07 #3

QVeen72

Hi,

You can Open a Dynamic RecordSet and add, using "AddNew" method, Instead of using an "Insert" Statment.

Also, you can use Escape Characters..

REgards
Veena

Dec 17 '07 #4

Killer42

There's also an article in the Access "HowTo's" on TheScripts which discusses the various issues around single and double quotes.

Dec 17 '07 #5

Torgg

I found this article to be very helpful in overcoming issues like this.

Always Use Parameters, even if you don't use Stored Procedures

Hope this was helpful,
Torgg

Dec 19 '07 #6