I have placed an ADODC data control on a form (named Adodc1)and I want to link it to either an Access2000 mdb or Access97 mdb whichever one works. I have tried both . I have used the following connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\test\My Documents\Ac2Vb\Order Entry1.mdb;Persist Security Info=False. Tested the connection and Vb says 'Test connection succeeded'.
Now I have placed a simple textbox on the form and set its data source to the ADODC data control (Adodc1). When I try to click in the data propertys field of the text box I get the message '[ADODC]:no record source specified.[ADO] command text was not set for the command object. I am confused cos I have set the data source to (Adodc1).