linking tables doesn't work with [] in SQL

[slybitz]

I'm trying to link a Sql Server table to my access table and I am able to do so but with one problem:
One of my fields is labled "Desc" in Access. SQL Server does not allow this so it automatically puts brackets around the field like so: [Desc]. So if I go into Access and try and change Desc to [Desc] to match SQL Server (so i do not get #Name? in every row) it will not let me. So the only way for me to get the data to link correctly from within access is to change the Desc name (to Descr for example) within both Access and SQL Server. This is the problem. I do not want to do this because all of my forms, reports and queries use the [Desc]. Any ideas as to how to resolve this problem?

Thanks!!

 

[jsteph]

Use Speed-Ferret (google it, and Black Moshannon Systems should come up), which will change all instances in all forms, reports, properties, etc. It's not very expensive, and it is extremely usefull.

I personally do not like having any reserved words as fieldnames, it's a pet peeve, and I'd highly recommend changing it now instead of working around it.
--Jim