MS Access connection

[PaulVL]

Paste your .odbc.ini settings to us. (blank out any confidential info)

I think you need to tweek the settings in it.

[ray.wurlod]

Did you create a System DSN or File DSN? DataStage will not work with a User DSN.

[BillB]

Also try checking the setting of your TMP and TEMP environment variables, in the context of the user that is running the DataStage job. This is easiest done by looking at the log entry headed 'Environment variable settings'.

The user that is running the ODBC job needs to be able to create subfolders in the TMP/TEMP folder. It can't always do this if the variable is set to some default value, eg C:\Windows\system32\config\systemprofile\AppData\Local\Temp.

[tine_bi]

Paste your .odbc.ini settings to us.

Looks like this
[ODBC 32 bit Data Sources]
MS_Access_TINE_Felles=Microsoft Access Driver (*.mdb, *.accdb) (32 bit)
[MS_Access_TINE_Felles]
Driver32=C:\PROGRA~2\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL

[tine_bi]

Did you create a System DSN or File DSN?

System DSN

But i now see something I am not sure is correct.

It resides in the 64- bit ODBC driver, when opening the 32-bit it is not listed, however, if I look at the odbc.ini I find this

[ODBC 32 bit Data Sources]
MS_Access_TINE_Felles=Microsoft Access Driver (*.mdb, *.accdb) (32 bit)
[MS_Access_TINE_Felles]
Driver32=C:\PROGRA~2\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL

Not sure if that has anything to do with it....

[tine_bi]

Also try checking the setting of your TMP and TEMP environment variables

Both resides in C:\WINDOWS\TEMP

[ray.wurlod]

Use the 32-bit ODBC Administrator (odbcad32.exe) to create a 32-bit DSN. You will probably find this in the SysWOW64 folder.