I've seen plenty of threads suggesting possible causes for this problem and numerous suggestions for possible fixes.
My Access 2000 database is split in to a back end of around 70-80Mb and 5 users on the front side. No one's exiting stupidly and nothing out of the ordinary is happening, but...here's the best bit...it breaks during the early afternoon each day!! I get all users to exit and then copy and compact using a compactor utility from peter's software.
I also do a compact each night just to keep it neat and tidy, so compacting isn't exactly being overlooked.
I've had the db for around 6 years and archive data out (carefully) every so often to keep it as small as possible. Through history it has been fine and i cope with running it with no major issues. One thing i have never come across though is any kind of event logging gadget that could be used to record what access was doing when it messed up, does anyone know of anything like this that can pinpoint potential problems?
Vince
PS - I'm about to upgrade to Access 2003, is it any more robust?
Plus, are there any differences that might stop my current code in it's tracks?
My Access 2000 database is split in to a back end of around 70-80Mb and 5 users on the front side. No one's exiting stupidly and nothing out of the ordinary is happening, but...here's the best bit...it breaks during the early afternoon each day!! I get all users to exit and then copy and compact using a compactor utility from peter's software.
I also do a compact each night just to keep it neat and tidy, so compacting isn't exactly being overlooked.
I've had the db for around 6 years and archive data out (carefully) every so often to keep it as small as possible. Through history it has been fine and i cope with running it with no major issues. One thing i have never come across though is any kind of event logging gadget that could be used to record what access was doing when it messed up, does anyone know of anything like this that can pinpoint potential problems?
Vince
PS - I'm about to upgrade to Access 2003, is it any more robust?
Plus, are there any differences that might stop my current code in it's tracks?