Tutorial by Examples

This should always be your initial fix. A good policy is to decompile the database before each release. Create a decompile shortcut. This loads the database with a "/decompile" switch. Right Click your Database File. Select Copy Right Click in the explorer window and select &quot...
If your crashes are random or sporadic, then do this step. If your crashes occur every single time you run the database, then this step won't fix the issue (although bad memory may be the reason why the corruption occurred in the first place). Use a memory tester that boots outside the operating sy...
Sometimes the crashes occur constantly in a single form or report, or occur only when printing. It is possible that the binary data within the form / report has become corrupt. Save the Form / Report object as text There are two undocumented functions. Application.SaveAsText and Application.Load...
If you have images or other data stored in Access itself as OLE Objects, then you should find a better approach. When the OLE data is stored, it is stored according to the software (and version of software) on the computer storing it. When another computer goes to display that OLE Object data on the...
This is a lot of work, so do this as a last resort after exhausting all other options. You only need to do this if the problem is occurring for different users, on different machines. If it isn't occurring for all users, then most likely it is not a corrupt database container. Similar to the steps...

Page 1 of 1