MS SQL Server ODBC - Incorrect syntax near '5' where 5 is the beginning of a field name

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Incorrect syntax near '5' where 5 is the beginning of a field name

2005-06-20, 3:23 am

Hi all

i get the following error
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'5'. (#170)
when trying to update or delete a record from an Access Linked table. Adding
a record is fine. There is a field called 5Years, but this has not been a
problem before. Only occurred when database was moved to a new server.

SQL server version on current and old server is 2000 sp3a

--
jw

Warren Read

2005-06-21, 8:23 pm

It's always been my understanding that fields can't start with certain
characters, like punctuation characters and numbers.

I'm surprised this ever worked. It may have been a bug that was fixed in
your recent release?

Perhaps someone else has a more knowledgeable response.

Sponsored Links