[Java] Need Help with ODBC and Access Database

[Got3n]

So I have an access database, its a phone directory basically. I had it in an mdb format, i setup an ODBC connection under the system DSN. I chose the appropriate dirver and selected the database on my network drive, lets say Z:\access.mdb, i get the following error when the application tries to update the database from the file.

INFO   | jvm 1	| 2012/01/25 14:43:01 | java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at java.sql.DriverManager.getConnection(DriverManager.java:512)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at java.sql.DriverManager.getConnection(DriverManager.java:171)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at com.tenovis.apps.ospc.updateservice.UpdateTask.createResultSet(UpdateTask.java:200)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at com.tenovis.apps.ospc.updateservice.UpdateTask.run(UpdateTask.java:152)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at java.util.TimerThread.mainLoop(Timer.java:432)
INFO   | jvm 1	| 2012/01/25 14:43:01 |  at java.util.TimerThread.run(Timer.java:382)
[/CODE]

If i point the ODBC connection to the C:\ drive and copy the access.mdb there it works no problem. This database is updated by a service run by another program, I have run the service as a domain user who has full permissions to the shared directory and still come up empty, any help would be appreciated.

I dont want people messing the the sql database, so they update the access database, which in turn the application then accesses the database (access.mdb) and imports changes into the SQL database.

[Got3n]

nvm seems i got it working, didnt like Drive letter for network paths,had to use the actual UNC paths.