Returning data from access database

[#1]

I am new to qilview so appologies if there is a simple solution to this

I have Qlikview installed on my laptop and a simple Access 2003 database

I create an OBDC connection to the Access database - Microsoft Access Driver (*.mdb) as a system DSN

In 'edit script' i connect using the ODBC to the access database, I select all the fields from one table and add them to the script. The preview tab can see the data ok.

Back in 'Edit Script' I reload and get 'ODBC connection failed'

what am I doing wrong please

John

[#2 · Accepted solution]

Seems weird.

Try using OLEDB instead and see if it works?

[#3]

thanks

that worked