Once you have selected the database you want to access, click OK and then OK again to exit the dialog box. Within your services manager, make sure that the JOB service is running, and then open a web browser and go to the following URL This will open the JOB Web Administrator where you have many configuration options.Once the process has been completed, you can build interfaces and queries to the linked tables just as you would for any Access database.Use the following procedure to view links or to refresh them when the structures of the linked tables have changed.
Although Microsoft do not produce a JDBC driver for MS Access, Easysoft provide two Microsoft Access JDBC drivers.
JDBC connections support creating and executing statements.
These may be update statements such as SQL's CREATE, INSERT, UPDATE and DELETE, or they may be query statements such as SELECT.
The first test I did was to add another table in my Access database.
This was done by running the CREATE TABLE statement with the execute Update() method.