PDA

Click to See Complete Forum and Search --> : Could anyone help me how to get rid off this database corruption problem?


bakyaraj
Oct 30th, 2000, 04:15 AM
I have developed an application with MS-Access'97 as the backend
and visual basic 5.0 as the front end.It is a multi-user system.Currently more than 10 users are accessing the database at the same time.It's getting corrupted once in a week.The database size is nearly 150 MB.The coding was fully verified and there was no problem.I am using DAO 3.5 to access the database.To edit or add a record i am using only dynaset recordset type and for all other purposes snapshot type recordset.I am not using any begintran or committran in my program.
In the client place they are using novell network not microsoft.Is that causing the database corruption?

Could anyone help me how to get rid off this database corruption problem?

very urgent.

iandarbyshire
Oct 30th, 2000, 05:04 AM
Can I just check that you have taken record locking into account on the Access database.

paulw
Oct 30th, 2000, 07:57 AM
The most likely cause of corruption is somebody closing the database by turning off their PC - Novell networks are not a problem (some (i.e. Me) would say they are better than other Networks).

Good idea to do a compact and repair once a week anyway with a database of that size.

Cheers,

Paul