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

Reply via email to