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

[QVeen72]

Hi ,

Try to use Replace Function :
Something like this :

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

Regards
Veena

[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

[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

[Killer42]

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

[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