Entry

SQL "select * from Orders" returns no result set but I know there's data?

May 16th, 2000 22:30
unknown unknown, Alexandar Minkovsky, Michael Brinkley

Did your Orders table contain a field named Order? If so, this is a
reserved word - try using '[Order]' in your SQL statement.

I had a similiar problem recently. My table name was the same as the 
database name. When I changed the table name the problem went away. Try 
changing your table name to something like: CustOrders