The DSN which you setup in the deployment server should map to the location of the Access Database. for eg. if your DB resides on server X, then the DSN should have the //x/DBName.mdb in the path name for the mdb file so that your DSN can access the DB. So unless you have the path name for the database file you wouldn't be able to setup the DSN. The DSN should reside on your deployment server.
I wouldn't recommend using a
JDBC: ODBC bridge. It should be used only for
testing and prototyping. A type 3 driver is an alternative.