Or, set up filesharing and access then set up a system dsn on the machine you want to use it on. Can get a bit messy though with concurrent access :)
Daniel. > -----Original Message----- > From: Lee Harrington [mailto:[EMAIL PROTECTED] > Sent: 15 November 2004 18:34 > To: Struts Users Mailing List > Subject: Re: [OT] access Microsoft Access database from remote machine > > > 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]