Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Connect to odbc database - error message

Anonymous
Not applicable

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

2 Replies
Ratnesh_Ranjan
Level 3
Level 3

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

Anonymous
Not applicable

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