topic Returning data from access database in QlikView https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300795#M1199858 <HTML><HEAD></HEAD><BODY><P>I am new to qilview so appologies if there is a simple solution to this</P><P>I have Qlikview installed on my laptop and a simple Access 2003 database</P><P>I create an OBDC connection to the Access database - Microsoft Access Driver (*.mdb) as a system DSN</P><P>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.</P><P>Back in 'Edit Script' I reload and get 'ODBC connection failed'</P><P>what am I doing wrong please</P><P>John</P><P></P></BODY></HTML> Wed, 19 Jan 2011 17:30:06 GMT 2011-01-19T17:30:06Z Returning data from access database https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300795#M1199858 <HTML><HEAD></HEAD><BODY><P>I am new to qilview so appologies if there is a simple solution to this</P><P>I have Qlikview installed on my laptop and a simple Access 2003 database</P><P>I create an OBDC connection to the Access database - Microsoft Access Driver (*.mdb) as a system DSN</P><P>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.</P><P>Back in 'Edit Script' I reload and get 'ODBC connection failed'</P><P>what am I doing wrong please</P><P>John</P><P></P></BODY></HTML> Wed, 19 Jan 2011 17:30:06 GMT https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300795#M1199858 2011-01-19T17:30:06Z Returning data from access database https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300796#M1199859 <HTML><HEAD></HEAD><BODY><P>Seems weird.</P><P>Try using OLEDB instead and see if it works?</P></BODY></HTML> Wed, 19 Jan 2011 17:38:06 GMT https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300796#M1199859 2011-01-19T17:38:06Z Returning data from access database https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300797#M1199860 <HTML><HEAD></HEAD><BODY><P>thanks</P><P>that worked <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Thu, 20 Jan 2011 12:15:50 GMT https://community.qlik.com/t5/QlikView/Returning-data-from-access-database/m-p/300797#M1199860 2011-01-20T12:15:50Z