DSXchange

Hi All,

I have a job where I need to connect to the MS access tables in a different server and they are stored in a perticular folder in that server.
They are in .mdb format.

May I know if we can access them in any why using any of the stages.

Thanks for your help in advance.

You should be able to access them using an ODBC driver for MS Access.

Hi Ray,

Thanks for your info. But when i use the ODBC stage in server jobs,what username/pwd do i need to specify..is it the servername userid.pwd or ms access DB username/pwd to access those tables.

Thanks

Try the connection without a userid/password. Microsoft Access is not the most secure environments.....

That's why Diebold uses it for their vote tally machines :(

Ray D

Try the connection without a userid/password. Microsoft Access is not the most secure environments.....

That's why Diebold uses it for their vote tally machines :(

Ray D

FIRST OF ALL ,YOU CAN CREATE A DNS IN ADMINISTRATOR TOOL, USERID/PASSWORD IS A DNS, NOT DATA STAGE USERNAME/PASSWORD/

FIRST OF ALL ,YOU CAN CREATE A DNS IN ADMINISTRATOR TOOL, USERID/PASSWORD IS A DNS, NOT DATA STAGE USERNAME/PASSWORD/