Thanks Martin and Everyone else for the suggestions. Martin, Oracle I dont want to go with since its expensive. I will infact try out MySQL and will let you guys know.
Regards, Gaurav. On 11/18/06, Martin Gainty <[EMAIL PROTECTED]> wrote:
Good Morning Gaurav- It is truly Amazing how many managers who want to use Access DB in their production environments I would recommend a migration to true multi-threaded environment with a DB which has full Transaction support such as Oracle Take a look at http://www2.sys-con.com/itsg/virtualcd/Java/archives/0312/callahan/index.html specifically I would look at breaking single-tier to three tier architecture to decouple the application,business and DB to differing structures More immediate concerns would be migrating Type 1 (NonMultiUserAccess JDBCToOdbcBridge) to Type4 (True ThinCLient) JDBC driver Please keep us apprised on your progress, Martin --
Gaurav Singh Kushwaha Ph: +91-9880101496 Bangalore, India. http://www.chakpak.com