Bypass or solution for using syntaxis in Access database?

[Dreamiej]

Hi all,,

Im a rookie programmer and Im trying to make an errorprogram for work.
The problem that i have is: that i have a premade database which is Full of syntaxis.. one of the tablenames where i got a "insert into" error or an "syntaxis" error is at the following tablename (in dutch):

"Storings tabel"

There is a space between the words and it is not possible to remake the database because Its huge and Full with relations.

The error part is on the line with da.fill:

this is a part of the code with the error:

con.Open()

sql = "INSERT INTO Storings tabel(aanmelder) VALUES('" & TestTB.Text & "')"

da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Storings tabel")

Is there a way to bypass the "space" character?

I tried an underscore or Chr(32) But it wont work.

I hope someone can help, Thankss!

[VictorN]

Use it with [ ]:
[Storings tabel]
http://www.access-programmers.co.uk/...d.php?t=188963

[Dreamiej]

Use it with [ ]:
[Storings tabel]
http://www.access-programmers.co.uk/...d.php?t=188963

WoW! Many Thanks, This one worked for me!
Only I ran into a new problem in the database with the tabletext "Monteurs-Id"

There is a dash between the words, is there also an solution for? The brackets wont help me this time with [Monteurs-Id]..

[Dreamiej]

WoW! Many Thanks, This one worked for me!
Only I ran into a new problem in the database with the tabletext "Monteurs-Id"

There is a dash between the words, is there also an solution for? The brackets wont help me this time with [Monteurs-Id]..

I Helped myself,, Many thanks for helping VictorN!!

[VictorN]

I Helped myself,,

How?
Could you share your solution/workaround?