ok, ive been following the guide in beginning asp.net using vb.net and i 

can get the example to work fine on the northwind db, but it absolutely 

refuses to insert data in any way shape or form into any other database! 

the query itself works fine in access, so i doubt thats at fault..

The actual error asp.net is throwing back at me is "Exception Details: 

System.Data.OleDb.OleDbException: Operation must use an updateable query." 

which pops up at "objCommand.ExecuteNonQuery()"

As far as i can tell, theres nothing i've left out, as ive used the code 

from the book as a direct reference (directsql.aspx from chapter 13 of the 

book mentioned above) so is there anything special that the database or 

the connection needs? i cant seem to find any mention of anything like 

that anywhere, in books or on the web :/

If needs be i can paste the code