Sorry, I've only handled data via-code, plus I'm only a beginner in that.

Kev

>No connection code, i just dragged the table and dropped into the form , i created the data adapter, and in data adapter properties if you click on generate dataset i get the error.
>
>Thanks for looking into this
>
>
>>Hi
>>
>>I will require more info than that, like your connection code?
>>
>>Kev
>>
>>>Thanks i received your email, i created a data connection in VS.net and tried to configure the data adapater,but i get
>>>
>>>Data adapter configuration Error
>>>
>>>Error in SELECT clause: expression near '['.
>>>Error in FROM clause: near '['.
>>>Unable to parse query text.
>>>
>>>What am i missing ?
>>>
>>>txs
>>>
>>>
>>>>>Manipulating data.
>>>>
>>>>I haven't had any problems with the version of OLE DB releassed with version 8.0, do you want me to mail you a copy?
>>>>
>>>>Kev