Migrating Access to Sql Server

[spowel4]

One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run the queries in SQL Server. That's the backtick character, the one underneath the ~ on the keyboard. Has anyone seen this happen and can offer some insight as to why it happened and how to prevent it?

[pritaeas]

The backtick is something from MySQL. Is it placed around column names?

[spowel4]

I think they were around the column names; I can't be sure about that, though, until the programmer is back to work next week. I'll verify with them at that time & let you know. Thanks for the reply.