Our team maintains several java applications that currently all use the same Microsoft Access (2007) database. The ".mdb" file resides on a network share and is accessed concurrently by not more than fifty users. At least once a month the ".mdb" file gets corrupted and as a result the users cannot use the applications. In such cases we restore the database from a backup.
I am seeking an alternative database which will not "crash" and would like to hear suggestions since I have no experience with other databases in similar environments even though I have worked in the past with Oracle and Informix.
I have heard of mySql and PostgreSQL but have not experimented with them.
Thanks for reading and thanks (in advance) for your help.
Are you using a SPLIT db?
If its NOT split and many people use it , it will crash.
You MUST split the db to prevent this.
I am unfamiliar with this concept of SPLIT database that you mention so I looked it up on the Internet and I understand that it means splitting the database tables from other Access entities such as queries and forms.
Please note that our database contains only data - no forms and no queries.
The data is accessed exclusively via java applications, using JDBC.
The database contains approximately 20 tables where the largest table contains about 25,000 rows.
All table columns have data type of either VARCHAR or INTEGER.