Hi mate,
THanks alot for your help. I've tried your initial methods or eliminating ' and it still didnt work. But strangely enough, with my old coding, I've changed the update query to this and it...

Hi,
I have tried with the codes you suggested but it is still giving syntax error. I think the error is at this particular line:


Dim sqlupdate as String = " UPDATE item_table SET Total = Total...

Hi people, I'm having a small problem in ASP.NET + Microsoft Access. Here is my problem:

1) I have a table (item_table) with 3 fields
2) f1-ID, f2-Item, f3-Total
2) In my asp page, I am having 1...