|
Hello members...
I've seem to run into a little hole and need
somebody to help me out...
Scenario:
I have a application(sitting on server) where a
user(accesses application) enters a filename to his Access database. A
file ending in *.mdb is what they usually have to enter. Now, How would I
tell access that the file is sitting on another machine and not on the server,
because the way it works now, is that the server is looking for the file on its
local drives! Is there something missing the connection
strings:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + dest + ";Uid=;Pwd=;"); System.out.println("Class established and Connection made!"); I know that SQL has an attribute whereabout I can
speicify the server name and connect to that server, but I cannot seem to figure
one out for Access...
Any and all help is greatly
appreciated!
jags
|