What are settings needed for Configuring an adapter to retrieve data from MS Access database???
How can we compare two tables in the same database to check if all the values are identical or not ???
You will need to aquire and install the easysoft driver( this driver is available at easysoft website for some price) and then configure to connnect to the MS Access database from WmDB page (can be accessed from the left pane in the IS Admin page).
If you want to write a sql service using adapter,then you need to add a db link on the adapter page on the wm administrator page,but if you just want to using build-in service to get data from back-end db,then you can follow kiran_wajapey’s way.