Firstly, make sure that each user has their own copy of the front end. Do
not allow multiple users to open the same file.
Secondly, there is a bug in A2002 and 2003 that causes Access to crash where
you use subforms. It seems that if the LinkChildFields is an AccessField,
Access can intermittently crash. To stop this, open the subform in design
view, and add a text box to the subform for the foreign key field named in
LinkChildFields.
After that, perform a decompile by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
For further suggestions on preventing corruption, see:
http://allenbrowne.com/ser-25.html
There are several important points there, including making sure that every
user has the same version of msjet40.dll, and not editing running code.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"mr_mach7" <mr******@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I have an Access database that needs to be compacted and repaired
almost on a daily basis. It is the front end that needs to be fixed, so
other users cannot get into it when the problem happens. This is
driving me nuts and needs to be resolved.
The database was originally created in 97 and converted to 2002-2003
format. It is split into front-end and back-end. The it is placed in a
network share for multiple user access. There are only about 25 users
that use the db and on average 10 concurrent. I have rebuilt the db by
creating a blank 2002-2003 db and imported the objects. I have disabled
the "AutoCorrect". Open mode is shared. Record locking is "Edited
Record" and "Open databases using record-level locking" is enabled
(checked). I have compiled the code, then "compact/repaired", then
created an mde file.
Is there anything you can tell be that would stop this corruption
problem?