updating database

I have some problems with an update string in my database:

This is working:

strSQL12 = "UPDATE tablename SET age_group = 'Uninvolved' WHERE sample = 'Uninvolved (R.S.)'"

but if i try to put the tablename in a string(table) like this i get an error:

strSQL12 = "UPDATE" & table & "SET age_group = 'Uninvolved' WHERE sample = 'Uninvolved (R.S.)'"

Anyone know why?

You're missing some spaces

strSQL12 = "UPDATE " & table & " SET age_group = 'Uninvolved' WHERE sample = 'Uninvolved (R.S.)'"

strSQL12 = "UPDATE" & table & "SET age_group = 'Uninvolved' WHERE sample = 'Uninvolved (R.S.)'"

I do not see the space between the UPDATE and the table name nor the space after the table name. Unless you add spaces around your table anme in the table variable.

Thanks both of you. its working now!