Syntax Error in FROM Clause
Posted on 2001-06-22
syntax error in from clause.
i am using adodc control and OLE DB provider is: Microsoft Jet 4.0
then i give data base name. Test Connection Successed.
in record source : command-type: adcmdtable. and i select the table from that database.
then on the form, in text-box
datasource property: adodc1
datafield property: table of that selected database.
this is the way of how bound programming is done using adodc.
but when i click on datafield proprty i get error that says: SYNTAX ERROR IN FROM CLAUSE.
how to overcome from this problem?
i have exported as well as imported table to and from another database.
but problem remains the same.
if i export only one table that it's work fine but when i export any another table problem stated above arises.
i tried out copy and paste method.
means in fresh database i have copied all the records from those tables but that does not solve the problem.
if you can help me please help me out.
i used unbound programming(coding) but problem was not solved.