Sheley
Jun 29th, 1999, 05:16 AM
Dear Friend
I know this is very allaying. I feel the same way too. But can anyone explain to me what I have miss or done wrong. I have create a ado Data control and I have set the ConnectionString and have set the RecordSource. I have draw a TextBox and have set the DataSource to "adodc1" when I try to set the DataField there always a adodc1 error say "[MICROSOFT] [ODBC microsoft Access 97 Driver] Syntax error in FROM clause".
My program is user keyin the record they want to see and display the record. That a very simple task. And I am hold up by setting up the connection.
Question:
What does that message say does it mean I have set the datalink file wrong or I have set the SQL statement wrong but I alway use the simple one which is (select *from order)?
If that is something I done wrong what should I do to correct the problem?
Please Help me with my Problem. Thank You very much
Sheley
I know this is very allaying. I feel the same way too. But can anyone explain to me what I have miss or done wrong. I have create a ado Data control and I have set the ConnectionString and have set the RecordSource. I have draw a TextBox and have set the DataSource to "adodc1" when I try to set the DataField there always a adodc1 error say "[MICROSOFT] [ODBC microsoft Access 97 Driver] Syntax error in FROM clause".
My program is user keyin the record they want to see and display the record. That a very simple task. And I am hold up by setting up the connection.
Question:
What does that message say does it mean I have set the datalink file wrong or I have set the SQL statement wrong but I alway use the simple one which is (select *from order)?
If that is something I done wrong what should I do to correct the problem?
Please Help me with my Problem. Thank You very much
Sheley