Operation Must Use An Updateable Query / Sql - Vba

I am trying to create a very dynamic macro that will update different tables in a Database, depending on what the user chooses. Each table has of course distinct titles and informa

Solution 1:

Discard this line:

RecSet.CursorLocation = adUseClient

Or try it like this instead:

RecSet.CursorLocation = adUseServer

See the Remarks section at CursorLocation Property (ADO) on MSDN:

"If the CursorLocation property is set to adUseClient, the recordset will be accessible as read-only, and recordset updates to the host are not possible."

Solution 2:

You're concatenating a string here - "SELECT * FROM Customers" & Tabla , but I don't see where Tabla is being provided.

Have you tried running the query directly in Access? Also, have you tried changing cursortype yet? http://www.w3schools.com/ado/prop_rs_cursortype.asp