Re: [OT] access Microsoft Access database from remote machine

2004-11-15 Thread fzlists
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 a

RE: [OT] access Microsoft Access database from remote machine

2004-11-15 Thread Daniel Perry
sers 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 sam

Re: [OT] access Microsoft Access database from remote machine

2004-11-15 Thread Lee Harrington
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 databaseset a local connection from that tomcat...and call a java procedure on the remote tomcat, which

[OT] access Microsoft Access database from remote machine

2004-11-15 Thread Ashish Kulkarni
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 Ash