Hi all,

quick question..
Can Sun's odbc driver be used (from a java app on one computer, which incidentally happens to be a unix box) to connect to an MS Access database on another computer (a windows one)?

I was thinking a connection string such as "jdbcdbcriver={Microsoft Access Driver (*.mdb)}; DBQ=//somehost:someport/c:/foo.mdb" would be half-intuitive, but after some googling I'm still coming up short with explanations of why it doesn't seem to work.

Any suggestions? Is it possible?
Thanks in advance!