Reading MS Access table data using OLE

[stefan_kolev4]

Hi,

The purpose of the code below is to connect to MS Access DB which is located on my PC.

It is a simple mdb file w/o user name and password and only one table inside.

Everything looks simple and easy, but unfortunately I receive an error sy-subrc = 2 imediatelly after

CALL METHOD OF CONN 'Open' EXPORTING #1 = SQL.

Please advise what is wrong, why I am not able to connect to the mdb file !

Thanks in advance !

Stefan

REPORT Z_OLE.

TYPE-POOLS OLE2.

DATA: CONN TYPE OLE2_OBJECT,

RSDB TYPE OLE2_OBJECT,

SQL TYPE C LENGTH 1024.

DATA: BEGIN OF WA_TEMP,

VALUE TYPE C LENGTH 1024,

END OF WA_TEMP,

IT_TEMP LIKE STANDARD TABLE OF WA_TEMP.

DATA: BEGIN OF WA_CONTACTS,

FName(20) TYPE c ,

LNAME(20) TYPE c,

END OF WA_CONTACTS,

IT_CONTACTS LIKE TABLE OF WA_CONTACTS.

START-OF-SELECTION.

CREATE OBJECT CONN 'ADODB.Connection'.

CREATE OBJECT RSDB 'ADODB.Recordset'.

• MDB Connetion infomations

CONCATENATE 'Provider=Microsoft.Jet.OLEDB.4.0;'

'Data Source=C:\HoHDB\Test.mdb;'

INTO SQL.

CALL METHOD OF CONN 'Open' EXPORTING #1 = SQL.

• Query Statement ...

SQL = 'SELECT * FROM CONTACTS'.

• Run Query

CALL METHOD OF RSDB 'OPEN'

EXPORTING #1 = SQL

#2 = CONN

#3 = '1'.

[stefan_kolev4]

Sorry Guys,

I've found the answer The problem was the version of the Access DB, I was using the latest version, but when I saved it as Access 2000 it works. I will do additional investigation regarding that issue.

Thanks,

Stefan