I have a user who called me about an Access DB that worked on Friday, but not today... (If I had a dollar for every time...) She said she installed Project 2000 between the last time she used it and today.

Turns out the code that it now hates is along the lines of this:

Dim objXL as New Excel.Application
With objXL
End With

When running, it errors on With objXL and says Error opening DLL.

The references are set properly and new code written using the above syntax cause Dr Watson to create a log file and kills Access as soon as I type the period for the .whatever

Any ideas?