SQL noob question: ODBC fail

[Lavey]

Hi guys,

I have a test server setup and have imported a database from Access (of which went fine). I have created an odbc dsn and tested in the odbc data source manager window (all tests successfully completed), yet when I link the tables into my new access database it creates the link (can see tables design) but it throws the following message:

ODBC -- call failed
[microsoft][odbc sql server driver][sql server]incorrect syntax near the keyword 'SET'. (#156)


I have looked up this error on the net and found two answers (1, incorrect tSQL in query?, 2, DDO buffer overflow), both of which mean not a great deal to me

So, my question is... is this a set-up problem of my table or odbc?
Many thanks in advance for any pointers ..

The sql noob

____________________________________
Eat , Sleep , Live

 

[Lavey]

ok.. to add something else to the mix.. i added a test table and can link my access db to it via same odbc dsn. so must be a table problem.. ?
Any ideas what could cause this failure ?

____________________________________
Eat , Sleep , Live

 

[Lavey]

ok.. found the problem.. the table i was importing had a field named: Set.
Was being changed to show [set] within my table thus causing a problem.



____________________________________
Eat , Sleep , Live