> I have this very very unusual and frsutration problem.
> I have an ADO data control on my form.
> Now I am trying to connect ado control to an access db.
> Now when I connect this ado to any table in this db I have no problem.
> But for one simple table when I try to connect, I have this error "Syntax
> error in FROM clause"
> Now this error occurs when I am trying to bind a text box to the field of
> the table, ie. when I am trying to set the Datafield property of the text
> box after setting datasource property.

> Any clues anybody ???

> Abhi

> Can you post the SQL phrase?
> OR,
> copy and paste it into an SQL view query design in your database (allowing
> for minor puncutation changes) and see if it produces an error on any
field.

> > I have this very very unusual and frsutration problem.
> > I have an ADO data control on my form.
> > Now I am trying to connect ado control to an access db.
> > Now when I connect this ado to any table in this db I have no problem.
> > But for one simple table when I try to connect, I have this error
"Syntax
> > error in FROM clause"
> > Now this error occurs when I am trying to bind a text box to the field
of
> > the table, ie. when I am trying to set the Datafield property of the
text
> > box after setting datasource property.

> > Any clues anybody ???

> > Abhi

> This is the strangest problem I have ever seen.
> Thanks for taking the time to reply, but I was able to solve the problem
by
> the changing the table name.
> so for example my table name was "Order", now when I have changed it to
> p_Order it works fine
> But if I change p_Order back to Order I have this problem.
> Thanks anyway though.

> Abhi


> > Can you post the SQL phrase?
> > OR,
> > copy and paste it into an SQL view query design in your database
(allowing
> > for minor puncutation changes) and see if it produces an error on any
> field.

> > > I have this very very unusual and frsutration problem.
> > > I have an ADO data control on my form.
> > > Now I am trying to connect ado control to an access db.
> > > Now when I connect this ado to any table in this db I have no problem.
> > > But for one simple table when I try to connect, I have this error
> "Syntax
> > > error in FROM clause"
> > > Now this error occurs when I am trying to bind a text box to the field
> of
> > > the table, ie. when I am trying to set the Datafield property of the
> text
> > > box after setting datasource property.

> > > Any clues anybody ???

> > > Abhi

> This is the strangest problem I have ever seen.

> Thanks for taking the time to reply, but I was able to solve the problem by
> the changing the table name.
> so for example my table name was "Order", now when I have changed it to
> p_Order it works fine
> But if I change p_Order back to Order I have this problem.

> > This is the strangest problem I have ever seen.

> It's not that strange, nor that uncommon; there's a very simple (and
> obvious if you think about it) explanation.

> > Thanks for taking the time to reply, but I was able to solve the problem
by
> > the changing the table name.
> > so for example my table name was "Order", now when I have changed it to
> > p_Order it works fine
> > But if I change p_Order back to Order I have this problem.

> "Order" is a reserved word in SQL (as in ORDER BY <field>). You can't use
a
> reserved word as an object (table, field, etc.) name, so you either have
to
> escape the name using brackets, e.g.:

>   SELECT <field>, <field> FROM [Order]

> or, preferably, rename the field, as you have done.

> hth

> Adam