Access Tables

[adam01]

Hi. I have an existing Microsoft Access database which I need to manipulate through VB. However, when I use my ado connection on some tables I get the message "SYNTAX error in FROM clause". It works just fine with other tables. Could it be something to do with the format of my Table fields or names in Access, or are there some types of data which are incompatible. I'm at a loss. Any help would be appreciated. For instance my Customers table has just customer and shipping info in it, but it won't work with my Time Billed table which has dates, times, and mostly text fields.

[Stevie]

Could be as simple as something spelt incorrectly in your SQL statement.

[Clunietp]

are you putting brackets around TIME BILLED?

Ex:

Select * from TIME BILLED....

will give you an error, but this will work:

Select * from [TIME BILLED]....

[adam01]

Thanks for the replies guys. I am using the ADO component to build and select my connection as well as select my tables. It is VB that creates the statement. Any idea?

[Clunietp]

Don't use the VB Designers, or dont use spaces in your table names (assuming that is the problem)