anandmehta
asked on
Syntax Error in FROM Clause
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.
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.
AzraSound
please update your other open questions before continuing here. failure to maintain your questions is grounds for account termination at this site.
You have to Select a Table in the Recordsource property of your datacountrol.
or enter a sQL statement.
THEN you can pick the datafield.
or enter a sQL statement.
THEN you can pick the datafield.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.