Access is a file-based database, and really it's just a data file in the end, the driver is what services queries and such. So, as Lee said, you'll need something to service the requests in between your client (i.e., your application) and the .MDB file. A remote server process could do this as Lee suggests.
Depending on how thing are for you, it might also be possible to set up the DSN on the server and point to a network drive on the remote machine. The Microsoft Access driver does support that, so if your environment is such that you could do that, there you go. Otherwise, your going to have to roll your own solution along the lines of what Lee suggested. You could probably write your own primitive JDBC driver to interact with the remote application that locally accesses the .MDB, so at least from the perspective of your client application it's transparent access. Writing JDBC drivers isn't terribly difficult, if you don't need to implement all the possible functionality. -- Frank W. Zammetti Founder and Chief Software Architect Omnytex Technologies http://www.omnytex.com On Mon, November 15, 2004 1:34 pm, Lee Harrington said: > Microsoft Access is not a "database server" -- it is not designed to > be run on a local machine and process sql sent to it. > > However, you could set up tomcat on the same machine as the access > database....set a local connection from that tomcat...and call a java > procedure on the remote tomcat, which will locally access the Access > database...and return data to you. > > Lee > > > On Mon, 15 Nov 2004 10:25:46 -0800 (PST), Ashish Kulkarni > <[EMAIL PROTECTED]> wrote: >> Hi >> Has any one accessed Microsoft access database from >> remote machine, currently if i have to use JDBC-ODBC >> brige i have to create a system DSN and then use this >> to access data, >> but if i dont have the database on my local machine, >> or any drive mapped to my machine how do i access it >> using JDBC >> >> Ashish >> >> __________________________________ >> Do you Yahoo!? >> Check out the new Yahoo! Front Page. >> www.yahoo.com >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
