Connect to odbc database - error message

[Former Community Member]

Hi,

I have created an access database that my form uses to lookup using a dropdown list, when I enter the sql statement in the oledb connection I get the following error message.

sql statement: select firstname, surname from table1;

error message: could not execute the query "select firstname, surname from table1;".

My database is simple and does not have any password controls.

Does anyone know what is causing the error message and how to solve it?

Thanks

Wyn

[Ratnesh_Ranjan]

Hi wyn,

Did you create the system DSN? This external video (http://www.youtube.com/watch?v=C56_Cz-aE0c ) shares a good example of accessing MS Access Table within LC Designer.

Regards,

Ratnesh

[Former Community Member]

Hi,

Yes, my data source was using the wrong access driver.

However whilst my data binding now works, I cannot save my pdf form with the dropdown selection I want from the database.  Everytime the form is re-opened it returns to the first record from the database and not the one chosen when the pdf was saved.

Please can you help me retian the chosen record?

Thanks

Wyn