Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
16 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Use complete UNC path.

Regards

ASHFAQ

Not applicable
Author

Hi Mohammed,

Can u elobrate this clearly.

Thanks,

Ashok.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Check the attached file with connecting strings

1st one locally

Second one from shared server.

Regards

ASHFAQ

Not applicable
Author

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.

ashfaq_haseeb
Champion III
Champion III

No need to install MS office

Enough in storage server

Regards

ASHFAQ

Not applicable
Author

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.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

ashfaq_haseeb
Champion III
Champion III

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