Corrupt Database

[macksta]

Hey guys,
I have got a .mde on a network drive that people access most days of the week but sometimes it corrupts and i get they get the message saying that "You or another user has unexpectedly quit". If i log every one out of the db delete the ldb file and load up the db on my PC it repairs it and everything is fine. We are running on Win2k I develop in access 2k and they run it on access runtime 2000 (can run access mdes but not develop). I would appreciate it if someone could explain to me why this happens nad/or a resolution for this problem if there is one.

Cheers Jamie Mack

 

[KenReay]

hi

Do you have you database split into 'front end' / 'backend' configuration?

What I mean by this is you put the code, forms, queries (not tables) into one db (the front end), and the tables into another (the backend).

The FE is located on each client PC, the BE is located on a (the) shared Netwrk Drive.

In the FE you link to the tables in the BE using File\GetExternalData\Link.

It is usual to have code in the FE which checks that the links are not broken, and relinks if necessary.

It is also usual to have an automated way of down loading new versions of the FE to each PC.

This approach has three main advantages:

It reduces network traffic and speeds load time of the application

It reduces corruption

It makes 'offline' development/testing etc easier, you just have a development copy of the FE which is linked to a 'copy' of the datatables, for development/testing

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com