Replies To: update query with accesss database in vb 6

Re: update query with accesss database in vb 6

Posted 06 September 2017 - 12:30 PM

For an update statement you would use an Execute method, such a statement does not return a recordset.

I do question your structure though. "Grade 08 - A" is two pieces of information, with the word "Grade" also seeming redundant. If the two values were in two separate columns it would be much easier to update and to query (and would follow database design principles). "Grade 08 - A" would still be easy to recombine if you needed this version for some display purpose.