I'm using a odbccommandbuilder to generate update commandos after I've made adjustments in my dataset. The problem is that a tablename can contain spaces. That's not a problem when you put the tablename between brackets (i.e. [volledig afgewerkt nl]) , but the commandbuilder doesn't do this, so I get errors that my updatestatement isn't correct.

this is an extract from my code:

adap.SelectCommand.CommandText = "SELECT " & veldstring2 & " FROM [" & tabel & "]"
adap.Fill(ds, "*")
Dim cmdbd As New Odbc.OdbcCommandBuilder(adap)

'code to adjust the dataset
Try
adap.Update(ds, ds.Tables(0).TableName)
Catch errr As Exception
....
End Try

This is the error message:

ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

and this is the automatically generated updatestatement:

UPDATE verkeerd nummer nl SET CITY = ? WHERE ( ((? = 1 AND CITY IS NULL) OR (CITY = ?)) AND (indice = ?) )
1

So all would be fine if the command builder would just put the tablename between brackets like this [verkeerd nummer nl]

Is there a way I can force this?