Re: Converting Access database to SQL server or Informix

Nils Myklebust <Nils.Myklebust@nmdata.com> wrote in article <35bca4df.15528203@news.newmedia.no>... > While I where away an anonymous Access Developer wrote: > > > Have you ever tried to run 1000 users connected to the same database > using an MS Access front end? Did it work well? Did it give all users > good response time? Would other solutions have given better > responsetimes? I certainly never have. Have you? If so, could you explain by what mechanism java is able to accomplish this non-trivial task with such robustness? I am working on a project that has approximately 200 users and am looking for ways to improve performance. I use MS-Access and Openlink ODBC to connect to informix. Is JDBC that much better/faster? Why? Thanks in advance for the info!