topic Reading Access 97 Database problems in QlikView https://community.qlik.com/t5/QlikView/Reading-Access-97-Database-problems/m-p/443377#M165265 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #333333; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">Using V10 SR 5 and trying to read an Access 97 Database, which has workgroup permissions. Forcing 32 bit OLE DB to get at the Jet 4 OLEDB or ACE OLEDB (same issue with both) and can get a successful Test Connection. I can then Select a table and even preview the data.</SPAN></P><P></P><P><SPAN style="color: #333333; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">The problem comes when I try and Reload the data, it fails’ to connect to the database and a screen below appears. Entering the username and password again has no affect.</SPAN></P><P></P><P><SPAN style="color: #333333; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">Any suggestions</SPAN></P><P></P><P></P><P><IMG __jive_id="23907" class="jive-image-thumbnail jive-image" onclick="" alt="Untitled.jpg" src="https://community.qlik.com/legacyfs/online/23907_Untitled.jpg" width="450" /></P></BODY></HTML> Tue, 23 Oct 2012 10:45:19 GMT 2012-10-23T10:45:19Z Reading Access 97 Database problems https://community.qlik.com/t5/QlikView/Reading-Access-97-Database-problems/m-p/443377#M165265 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #333333; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">Using V10 SR 5 and trying to read an Access 97 Database, which has workgroup permissions. Forcing 32 bit OLE DB to get at the Jet 4 OLEDB or ACE OLEDB (same issue with both) and can get a successful Test Connection. I can then Select a table and even preview the data.</SPAN></P><P></P><P><SPAN style="color: #333333; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">The problem comes when I try and Reload the data, it fails’ to connect to the database and a screen below appears. Entering the username and password again has no affect.</SPAN></P><P></P><P><SPAN style="color: #333333; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">Any suggestions</SPAN></P><P></P><P></P><P><IMG __jive_id="23907" class="jive-image-thumbnail jive-image" onclick="" alt="Untitled.jpg" src="https://community.qlik.com/legacyfs/online/23907_Untitled.jpg" width="450" /></P></BODY></HTML> Tue, 23 Oct 2012 10:45:19 GMT https://community.qlik.com/t5/QlikView/Reading-Access-97-Database-problems/m-p/443377#M165265 2012-10-23T10:45:19Z