Hi Javed,
Is your ODBC source PA set up as a
system datasource?
Does the ODBC connection work? You could use an ODBC
Test Utility (Google for it) to see if the ODBC datasource works.
Does the (operating system) user that runs the
java application have rights to access the Access file on the network?
Is the failing database on the network the same one as the succeeding database on your computer?
Can you show us how you configured the ODBC source?
What does "fails" mean? Can you show us the complete error message?
(aside: MS Access is not really suited for network access.)
Regards, Jan