Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Connect to Ms Access files?

Hi All,

I have one question.

Can we connect to Ms access data files (.mdb files) which is stored in different server. can we get data from different server?

if yes what are the details required to connect to Ms access database?

Thanks,

Ashok.

1 Solution

Accepted Solutions
Highlighted

16 Replies
Highlighted

Hi,

Use complete UNC path.

Regards

ASHFAQ

Highlighted
Not applicable

Hi Mohammed,

Can u elobrate this clearly.

Thanks,

Ashok.

Highlighted

An UNC path is something like:

\\servername\pathtofiles\database.mdb

Before you can use this kind of path, the database directories must be shared on your network by Windows. See Directory->Properties->Security&Sharing

Highlighted

Hi,

Check the attached file with connecting strings

1st one locally

Second one from shared server.

Regards

ASHFAQ

Highlighted
Not applicable

Tx for ur reply,

for that we need to install Ms office software in both server or only enough in storage server.

example:

server1: having mdb files

server2: reading data from server1. in server2 need to install Ms office or not required.

Thanks,

Ashok.

Highlighted

No need to install MS office

Enough in storage server

Regards

ASHFAQ

Highlighted
Not applicable

Don't consider this as a silly qusetion.

If we don't install in server2 then how we will create connection string because when we connecting  through OLE DB it's not showing that option "OLE DB Provider for MS Access".

See below image in server MS Office not installed.

Highlighted

If you're asking this question because otherwise you will not be able to configure an OLEDB/ODBC connection to the MS Access database files, then don't worry. You won't need MS Office anywhere.

The ODBC/OLEDB drivers can be downloaded from the Microsoft download site.

Highlighted

Hi,

Make sure you select force 32 bit.

OLEDB jet 4.0 comes by default.

If not available then go for Microsoft access database engine drivers.

And you don't need office to be installed to make connection.

Have a look at attached image.

All you have to make sure is your storage folder is accessible from Qlikview server.

Regards

ASHFAQ