[AccessD] Error loading DLL (CurrentProject.Connection)

Hi all

I've now seen this error twice. Both times for code like this:

 Dim rst As ADODB.Recordset
 Set rst = New ADODB.Recordset
 rst.Open "tblTable", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

The compiler stops at the line with rst.Open with the error message in
the subject.

After much trouble and testing, a reinstall (or update) of the MDAC
did it in both cases. No explanation why.

You can locate and download this from the Microsoft site:

  http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en

/gustav