Database Syntax Error

[StylinLancer]

Ok I am using the ADODC and DataGrid on my form. I am connecting to a database on my local drive which was tested last week. Now when I come back to do the same thing, once I establish the datasource on the datagrid to adodc1, a little message box pops up and says "Syntax Error in From clause"

What in the heck is this saying and how to fix it? I am not using code anywhere and I'm a little confused at where to begin.

[halawadh]

Syntax Error in From[B] clause
I Think There Is a Problem In The Table Which You Are Reading From
Check It's Name And Structure
I Hope You Will Find The Bug.

[StylinLancer]

Yeah I am thinking thats where the problem lies at. Not sure where to begin at the table level.

I also get unrecognized database format some times. Seem as though Access 97 files work fine but Access 2000 doesn't work. Any ideas here?

[pclement]

PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or 2002

What is the RecordSource of your ADODC control?

[StylinLancer]

I believe the recordsource was one of tables within the mdb.

[pclement]

Can you identify the name of the table? The only thing I can think of is that the name of the table or name of a column is a reserved word.

[StylinLancer]

I dont have access to the program right now. I'll take a look and double check it tonight......