Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: Roedy Green Newsgroups: comp.lang.java.databases Subject: Re: Accessing 2 tables having same name but different databases ms-access Date: Mon, 25 Apr 2011 13:44:24 -0700 Organization: Canadian Mind Products Lines: 21 Message-ID: References: <38947d04-5131-4725-a2bf-a3bee316a814@q6g2000prl.googlegroups.com> Reply-To: Roedy Green NNTP-Posting-Host: RCd/Ul4tyxGUBII8WGwa5g.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org X-Notice: Filtered by postfilter v. 0.8.2 X-Newsreader: Forte Agent 6.00/32.1186 Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:8 On Mon, 25 Apr 2011 03:45:08 -0700 (PDT), ruds wrote, quoted or indirectly quoted someone who said : >I have an application with MS-Access as backend and JSP/ tomcat as >frontend/webserver. >For getting better response time(as access is very slow compared to >other RDBMS's) Access by some definitions is not a multi-user database. There are a number of products that are and are free. E.g. PostGreSQL, MySQL, Derby JavaDB... see http://mindprod.com/jgloss/sqlvendors.html -- Roedy Green Canadian Mind Products http://mindprod.com Politicians complain that Kindles and iBooks are killing jobs by destroying the paper book industry. I see it that they have create a way to produce books for less than a third the cost without destroying forests and emitting greenhouse gases in the process. They have created wealth. They are encouraging literacy and cutting the costs of education.