I have a vb.net app that needs to update a table from another table withing the database. The statement im having problems with is as follows:
"Update Transactions set Kcatagory = Category " & _
"from transactions T inner join Kkp K " & _
"on T.Kprefix = K.prefix and T.Knumb = k.suffix"
ITs a access database
I can get the statement to execute when I upsize the database and run the database thru MSDE but I cannot get it to execute in vb.net and access?