I have an Access Database whith a table name that contains a hash sign [BASIC#1]
My SQL statements work well when executed in MS-Query, but when I put the database onto the webserver, I get errors because of the hash sign. I assume that the hash sign has some special meaning in ODBC or an other layer.
SQL = "SELECT * FROM [BASIC#1] WHERE ([BASIC#1].[ID]=" & request.form("ID") & ")"
Is there a way of avoiding this problem - apart from renaming the table?