How to troubleshoot fatal system errors in Access 2002 running on Microsoft Windows 2000 (294301)

MORE INFORMATION

Application-related problems

Confirmed bug in Access 2002

Sometimes, a fatal system error can be caused a bug in an application. When this problem occurs, you may receive an error message that is similar to the following: You can view details about the error by clicking the text click here. When you do this, you will see information such as what file was involved in the error and the memory offset at which the error occurred.

You can find more information about any known Microsoft Access problems that may cause fatal system errors by searching on the following words in the Microsoft Knowledge Base: For additional information about examining error messages in Windows 2000, click the article numbers below to view the articles in the Microsoft Knowledge Base: Note You can paste most Windows 2000 error messages to the Clipboard in a text format by pressing CTRL+C. Pressing CTRL+C converts the error message to text and copies it to the Clipboard. You can then paste the message into another program, such as Notepad. Note that you may not be able to capture all error messages. Also, you may not be able to capture dialog boxes that contain graphics.

Damaged or fragmented database

If the fatal system error occurs only when you open or use a particular database file (*.mdb), try to use the Compact and Repair Database command in Access 2002 to correct any potential problems that have been caused by damage to the database or by excessive fragmentation of the database structure. To do this, follow these steps:

1. Close the database. If you are in a multiuser environment, confirm that all users have also closed the database.
2. Make a backup copy of the database. You can use Windows Explorer to do this. However, we recommend that you routinely copy the database to another medium, such as to another drive, to backup tape, to a removable hard disk, or to a network drive for safe keeping. It is also a good idea to create a backup of the workgroup information file (*.mdw file). Access 2002 stores each user's preferences and security account information in this file. If you have implemented Access security, and this file is lost or damaged, you may not be able to start Access 2002 until you restore or rebuild this file.
   
   Note You can also back up individual database objects by creating a blank database and then importing the objects that you want from the original database.
3. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
4. Specify the name and the location of the database that you want to repair.

Note It is a good idea to regularly run the Compact and Repair Database command.

If the database still behaves unpredictably after you run the Compact and Repair Database command, or if you receive a fatal system error, either immediately or after continued use, try the additional troubleshooting steps that are described in this article to find the cause of the page fault.

Corrupted database

If the Compact and Repair Database command does not solve unpredictable behavior or application-related fatal system errors, try to create a new database. Import objects from the old database into the new database. Then, compile all the modules in the new database.

Note This method is not recommended if your database is a replica in a replica set. If your replica is corrupted, you should create a new replica from the Design Master.

To create a new database and to import objects from the old database, follow these steps:

1. Create a new Access 2002 database.
2. On the File menu, point to Get External Data, and then click Import.
3. In the Import dialog box, click Microsoft Access (*.mdb) in the Files of type list.
4. In the Look in box, select the drive and the folder that stores the old Microsoft Access database that you want to import.
5. Click the file, and then click Import.
6. Click one or more objects to import. You may want to select only one or a few objects at a time to make it easier to identify any corrupted objects.
7. Click OK to import the selected objects. If an object generates an error while the object is being imported, the object is probably damaged beyond repair. At that point, you should import the object from a backup database or re-create the whole object. The error may have kept other objects from being imported. Repeat steps 2 through 6 until you have imported all the other objects into the new database. One method is to import all tables, then all forms, then reports, and so on. If an error occurs within a group of objects, try to import smaller blocks of objects or try to import one object at a time, depending on how many object you have, from that group until you find the object or the objects that cause an error.
8. Compile all the imported modules in the new database. To do this, follow these steps:
   1. In the Database window, click Modules.
   2. Select a module, and then click Design.
   3. On the Debug menu, click Compile <database name>.
9. Close Access 2002.

Note If your original database contains references to libraries or to projects, you should make a note of the references. Then, open an existing Visual Basic for Applications (VBA) module or a new VBA module in your new database and click References on the Tools menu to add the same references to your new database.

If a damaged, fragmented, or corrupted database was the cause of the unpredictable behavior or of the application-related fatal error, you should not see these problems the next time that you run Access 2002 and you open the new database. If you see the same problems in the new database, try the additional troubleshooting steps that are described in this article to determine the cause of the problem.

For more information about how to repair Access 2002 databases, click the following article number to view the article in the Microsoft Knowledge Base:

Damaged installation

The problems that you are seeing may be related to the way that Access 2002 is installed on your computer. If you have another computer available that has Access 2002 installed, try your database there. If you suspect that the cause of a fatal system error or of unpredictable behavior in Microsoft Access is related to the application and not to any particular database, the problems may result from such things as incorrect settings in the registry or from one or more missing or corrupted Microsoft Office XP files. To see if this is the case, try to repair your installation. If repairing the installation does not solve the problem, try to remove and then reinstall your installation. Repair the installation

1. Start Access 2002.
2. On the Help menu, click Detect and Repair.
3. If you are prompted, insert the CD for Access 2002 or for Office XP. You may not be prompted if you installed Access 2002 from a network.
4. Continue through the Setup process until the repair is finished.
5. When the Setup process is finished, start Access 2002 again. Then, perform the same steps that you performed earlier to cause the error. If you still receive a fatal system error or if Access 2002 behaves unpredictably, either immediately or after continued use, you should try the additional troubleshooting steps that are described in this article to determine the cause of the problem.

Remove and then reinstall the installationIf repairing the installation did not solve the problem, try to remove and then reinstall Access 2002 or Office XP.

Note If you have Microsoft Visual Basic with Microsoft SourceSafe installed, you do not have to remove the Visual Basic program. You only have to remove the SourceSafe component.

To remove and then reinstall the installation, follow these steps:

1. Click Start, point to Settings, and then click Control Panel.
2. In Control Panel, double-click Add/Remove Programs. The Add/Remove Programs dialog box appears.
3. Select the program to remove, and then click Add/Remove.
4. Follow the instructions to remove all of the programs.
5. Reinstall Access 2002 or Office XP. To do this, follow these steps:
   1. Click Start, point to Settings, and then click Control Panel.
   2. In Control Panel, double-click Add/Remove Programs. The Add/Remove Programs dialog box appears.
   3. In the dialog box, click Install.
   4. Follow the instructions in the installer.

System-related problems

This section discusses system-related causes for fatal system errors in Windows 2000.

Memory conflict

A common cause of fatal system errors is a memory conflict that involves a device driver, a system component, or some other loaded file. To troubleshoot a memory conflict, the first step is to restart the computer in Safe Mode.

Safe Mode bypasses startup files, including the registry, the Config.sys file, the Autoexec.bat file, and the [Boot] and [386Enh] sections of the System.ini file. Additionally, Safe Mode provides you with access to the configuration files. Only essential system files and device drivers, such as the mouse pointing device driver, the keyboard driver, and the standard VGA driver, are loaded. Therefore, Safe Mode is useful for isolating and solving memory conflicts.

To start Windows in Safe Mode, follow these steps:

1. Multiple Boot:
   
   If your Windows 2000-based computer is set up for multiple boot, the boot-up process stops at the Please Select the Operating System to start menu. Press F8.
   
   Non-multiple Boot:
   
   If your Windows 2000-based computer is not set up for multiple boot, press F8 when the Starting Windows... progress bar appears on the bottom of the screen.
   
   Note You may only have a few seconds to press F8.
2. By default, Safe Mode is selected. Press ENTER. You then see the words "Safe Mode" appear in the four corners of your screen.
3. After Windows 2000 is finished loading in Safe Mode, start Microsoft Access. Then, try to reproduce the fatal error.
   
   For more information about running Windows 2000 in Safe Mode, click the following article number to view the article in the Microsoft Knowledge Base:

   202485 Description of Safe Boot Mode in Windows 2000

   If you cannot reproduce the fatal error in Safe Mode, the cause is most likely system-related. It is not a problem with your installation of Access.
   
   Note Windows 2000 does not provide step-by-step confirmation. If you are troubleshooting fatal system errors with Access in Windows 2000, and this article does not resolve the issue, contact Microsoft Product Support Services. For more information about support options, visit the following Microsoft Web site:

   http://support.microsoft.com/select/?target=hub

Temp folder issues

You can sometimes experience unpredictable behavior in Microsoft Access when you do not have enough disk space for temporary files. You should periodically remove any leftover temporary files on your system. Also, make sure that you have at least 8 to 10 megabytes (MB) of free space on the hard disk that is available to your temporary (Temp) folder. You must first determine the location of your Windows Temp folder as well as verify the validity or your TMP and TEMP environment variables. To do this, follow these steps:

1. Click Start, point to Settings, and then click Control Panel.
2. In Control Panel, double-click System.
3. Click the Advanced tab, and then click Environment Variables. Note the box called User Variables for UserName with the columns Variable and Value, respectively. These are the TMP and TEMP environmental settings. Examples of valid settings are the following:

   TEMP = C:\TEMP
   TMP = C:\TEMP

   If these entries are not there, follow these steps:
   1. Click New. In the Variable Name box, type TEMP.
   2. Press TAB to move to the Variable Value box, and then type C:\Temp (or any other valid path and folder name).
   3. Click Set or OK to add these values to the User Variables for UserName box.
4. To create the TMP environment variable, repeat steps a through c.
5. Click OK to close the Environment Variables dialog box, click OK to close the System Properties dialog box, and then close Control Panel.
6. Start Windows Explorer and look for a folder with the same name and location as was listed in the User Variables for UserName box. If the folder does not exist, create it. An invalid temp setting can have serious effects on Microsoft Access. If you find that the folder indicated by the environment variable does not actually exist, either open Windows Explorer and create a new temp folder in that location, or repeat steps 1 through 3 to update the TEMP environment variable to a valid location.
7. Verify that the drive containing the TEMP folder has sufficient free disk space. Generally, you should make sure that the amount of available free space on the drive where the TEMP folder is located is at least twice the size of the largest database that you may open on this computer. For example, if your largest Access database file is 7 megabytes in size, make sure the drive on which the TEMP folder resides has at least 14 megabytes of free disk space.
8. Verify that the TEMP folder is empty. If files exist, you can delete any *.tmp files that are not currently in use. These files usually have a modified date earlier than the current session of Windows.
   
   Note It is recommended that you quit all Windows programs before deleting any *.tmp files.

Disk Cleanup utilityIn Windows 2000, you can delete many unused or temporary files with the Disk Cleanup utility. Disk Cleanup searches your hard disk, and then shows you temporary files, Internet cache files, and unnecessary program files that you can safely delete. You can direct Disk Cleanup to delete some or all of those files. To open the utility, click Start, point to Programs, point to Accessories, point to System Tools, and then click Disk Cleanup.

Video problem

Occasionally in Microsoft Access, you can experience page faults or unpredictable screen behavior because of a video driver conflict or an incorrect graphics hardware setting for your system. Video driver conflict To troubleshoot a video driver conflict, change your system's video adapter to Standard VGA, which should work with most monitors. To do this, follow these steps:

1. Click Start, point to Settings, and then click Control Panel.
2. Double-click Display.
3. Click the Settings tab, and then click Advanced.
4. On the Troubleshooting tab, move the Hardware Acceleration slider to the None setting (all the way to the left), and then click OK.
5. Click OK again to close the Display Properties dialog box, and then close Control Panel.

Printer driver problem

If you receive a fatal error or experience printing problems when you try to print in Microsoft Access, try to use the Generic/Text Only driver. To do this, follow these steps:

1. Click Start, point to Settings, and then click Printers.
2. Double-click Add Printer, and then follow the instructions in the Add Printer Wizard to install the Generic/Text Only printer driver.
3. Try to print from Microsoft Access with this driver.

Note If the printing problems exist for Generic/Text Only driver as well as another driver, the problem is most likely not driver-specific. However, if the printing problem seems to be corrected by using a different printer driver, follow these steps to remove and reinstall the first printer driver:

1. Click Start, point to Settings, and then click Printers.
2. Right-click the printer that you want to remove, and then click Delete on the menu that appears.
3. If you are prompted to remove all the files associated with the printer, click Yes.
4. Click Start, point to Settings, and then click Printers.
5. Double-click Add Printer, and then follow the instructions in the Add Printer Wizard to reinstall the original printer driver.
   
   Note If reinstalling the printer driver does not solve the printing problems, you can try using a different driver or the Generic/Text Only driver again. Also, you should contact the printer driver manufacturer to report the problem and find out if an updated driver is available.

Incorrect virtual memory settings

You can occasionally receive unexpected behavior in Microsoft Access when the virtual memory setting is too low for your system. Windows uses a dynamic virtual memory manager to handle swap file duties. You should use the default virtual memory settings whenever possible.

However, if you suspect that the unexpected behavior in Microsoft Access is caused by low virtual memory, you can try to manually change the virtual memory settings. If the maximum setting for virtual memory is already set, you may need to choose a different hard disk or remove files from the current hard disk to increase the amount of disk space reserved for extra memory. To increase the amount of hard disk space reserved for virtual memory, follow these steps:

1. Click Start, point to Settings, and then click Control Panel.
2. Double-click System.
3. Click the Advanced tab, and then click Performance Options.
4. Click Change, select a hard disk, and then adjust the Initial Size and Maximum Size settings as necessary. For information about these settings, click the question mark button ?, and then click the option about which you want information.
5. Click Set, and then click OK.

Hard disk fragmentation or errors

A fatal system error may be the result of disk fragmentation or hard disk errors. If this is the case, try to run one of the following tools to correct the problem.The Disk Error-Checking toolThis tool checks for file system errors and bad sectors on your hard disk. To run the tool, follow these steps:

1. On the desktop, open My Computer, and then select the local disk that you want to check.
2. On the File menu, click Properties.
3. Click the Tools tab.
4. Under Error-checking, click Check Now.
5. Under Check disk options, click the Scan for and attempt recovery of bad sectors check box, and then click Start.

The Disk DefragmenterThis tool analyzes your disk to determine the level of defragmentation, and can also defragment it. To use this tool, follow these steps:

1. Click Start, point to Programs, point to Accessories, point to System Tools, and then click Disk Defragmenter.
2. Select the drive that contains your Microsoft Access folder, and then click Analyze or Defragment.