Access 2000 problem opening .mdb

Tried opening an Access 2000 .mdb on Access 2000 and got this error prompt:

Compile error. in query expression ''. -(file info del'd)

I hit OK on that prompt, then a MS VB prompt popped up that said:

Run-time error '2467':
The expression you entered refers to an object that is closed or doesn't exist.

Options for that prompt are either <End> or <Debug> out.

When I get into debug, I do the Tools, References, and:

VB for Applications
MS Access 10.0 Object Library
OLE Automation
MS DAO 3.6 Object Library

are all checked and nothing shows as missing.

Same problem happens with OfficeXP.

Any ideas on getting this file to work? Thanks

w00t! Found it! Here's the fix:


Referencing the ADO Library

ADO 2.8 Programmer's Guide
In a Visual Basic Application

To import the ADO libraries into a Microsoft Visual Basic application, you must set a reference in the Visual Basic project.

To set a reference to the ADO libraries in a Visual Basic project :

• Create a new or open an existing Visual Basic project.
  
• Click the Project menu item and then select References... from the drop-down menu panel.
  
• From Available References, check the box for Microsoft ActiveX Data Objects n.n Library, where n.n stands for the latest version number. The Location field below should identify your choice as $installDir\msado15.dll, where $installDir stands for the path of the directory in which the ADO library has been installed.
  
• If you intend to use ADO MD, repeat step 3 to select Microsoft ActiveX Data Objects (Multi-dimensional) n.n Library . The Location field should identify this choice as $installDir\msadomd.dll.
  
• If you intend to use ADOX, repeat step 3 to select Microsoft ADO Ext. n.n for DDL and Security . The Location field should identify this choice as $installDir\msadox.dll.
  
• Click OK to finish setting the references.