There is a bug that has been fixed, but if you have an old dll file you may still run into it. First, check the version of vbe6.dll on your computer. To do this, click the Start button and choose Search. Type in the file name and let Windows find the file. Right click the file in the found files window and choose Properties then the Version tab. Check the version of the file. Version 6.3.91.8 is the troublesome version.
If you don't have this version of the file, then the problem is probably something different. If you do have this version, then try following the steps mentioned in the knowledge base article.
First, to keep this from happening again, get Service Pack 3 for Office 2000 and install it. To get this go to
http://office.microsoft.com/officeupdate/default.aspx?CTT=98
Next, fix the database you currently have.
1.. Open a form or a report in Design view.
2.. Save the code behind the form or the report as a text file.
3.. Set the form or the HasModule property of the report to No, and then save the object.
4.. Repeat step 1 through step 3 for each form and report in the database.
5.. Save each module as a text file.
6.. Create a new blank database.
7.. On the File menu, point to Get External Data, and then click Import. Import all tables, queries, forms, reports, data access pages, and macros to the new database.
8.. Restore the code behind each form and each report from the text files that you created in step 1 through step 4.
9.. Import each text file that you saved in step 5 as a new module.
You will need an new, blank, notepad file to save the text of the code from the modules in. You'll need to open each module, one at a time, in the code editor, select all of the text, choose copy (Ctrl+C), then paste it into Notepad (Ctrl+V). Keep track of which code came from which form/report so that you can copy it back later.
Open each form/report in design mode and set its Has Module property to No. This is located on the Other tab of the form's/report's Properties sheet.
Create a new, blank database. On the File menu choose Get External Data then click Import. Choose the old database file to import from and select all the tables queries, forms, reports, etc in the old database then click Ok.
Highlight each form/report one at a time in the new database and press the Code button on the toolbar. Copy the code for that form/report from your Notepad file and paste it into the code window. Once you have done this for each form and report (one at a time), in the code window choose Debug|Compile... from the menu bar and save changes.
