We are transitioning from a 2007 Access Backend to SQL Server. For reasons I won't go into, we have an Access table with several fields whose names contain quotation marks. For example,
["Marked Delete"elete Indicator] - without the opening/closing brackets. We have a large number of queries that reference these fields (with the quotes) successfully when it was in Access.



I have created the new Table without the quotes, however, I have created a View with the quotes so we won't have to change all the queries. When I try to open the views as a table in Access, I get an ODBC Call - failed and all the data appears as #Name.

Is there a way I can refer to these weird data names in Access without changing all my queries?

Thanks, Eddie