How to access a DSNless remote MS-ACCESS DB ?

I have tried this with local system and working fine.

String conString="jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};SERVER=myserver;DBQ=c:\\my.mdb";

I think here the SERVER is dummy. Even without SERVER its working fine with local system.

But assume the 'my.mdb' DB is in remote 'myserver' and how to access that from a local system as a client ?

Its saying "errorjava.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'."

(I knew that using type 3 and 4 we can do that. But Is there any way to do this without that ?)

I think Access is a desktop related application and doesn't support client server like SQL server.

Is that right ?

Expecting your answers......

[778 byte] By [nandakrs] at [2007-9-26 4:33:40]