topic Connect QV server 64bit to MSAccess in QlikView

Connect QV server 64bit to MSAccess

Mon, 26 Jan 2026 18:19:17 GMT

Hi all.

Can someone please help?

I am running a standard edition of 8.5 small business edition of QVS on a 64bit server.

Has anybody got any suggestions on how I can use this to connect and pull data from a MS access database ?

Connect QV server 64bit to MSAccess

Thu, 18 Jun 2009 00:11:59 GMT

You can't. I have the same issue. MS Access only has ODBC drives for 32 bit. You will have to load the 32 bit version of QV.

Stephen

Connect QV server 64bit to MSAccess

Thu, 18 Jun 2009 22:37:47 GMT

Thanks Stephen

Thats what I have done on the server and got it to generate a qvd file then import that.

Just seems really clunky .......

Connect QV server 64bit to MSAccess

Sat, 05 Sep 2009 02:55:41 GMT

I'm trying to do this with a SQL Server linked server definition.I was able to successfully create a linked server from one of our SQL Server 2000 boxes that has the MS Jet 4.0 ODBC driver on it. Then I took my query and ran it in Query Analyzer and got the results I expected.

Great, right? Wrong. I plugged the new connection string into my load script and ran it on my 32-bit Developer edition on my PC. (Not even wading into 64-bit territory yet, but that's where I need to get to for my Publisher.) I'm getting an error telling me "Invalid object < my table name >" and the query fails. Why? Is QlikView doing something other than passing this query on to the server for execution?

Any help is appreciated.

Connect QV server 64bit to MSAccess

smoon63 — Fri, 18 Dec 2009 22:21:10 GMT

It's more than likely not QlikView, but rather the ODBC driver. Especially with JET ODBC I have had similar issues in QlikView and others. The culprit usually turns out to be differences in string delimiting - i.e. single vs double quotes. In other instances it has to do with how field names are represented, square brackets vs quotes or similar.

A little late to the party, but I hope this helps.

Scott