Command OpenRecordset leads to Error 48

[Bo Hansson]

I´m controlling an MS Access Database 2016 from a VB application developed under MS Word. It have worked for years, through different Word and Access versions, but suddenly (over night) I get Error 48 (Cannot load DLL file) when executing an OpenRecordset command. What has happened, and how to mend it?

[ranman256]

what DLL?
are you opening a form with data?
are you using code to do something to a recordset? can you show us the error point?

are there any missing DLL in VBE, tools, references?

[Bo Hansson]

I dont know what DLL. Here is the code (execution stops on second line):

Set dbsData = OpenDatabase(strSökväg & "Databas\Lotta 2000.mdb")
Set rstData = dbsData.OpenRecordset("Data")

But, again - it has worked for years Now, suddenly this problem!

[John_G]

"Overnight" - Might MS have automatically applied some sort of update (they like to do that) that you didn't notice? If so it could be that the update failed to complete properly, resulting in a missing DLL. As Ranman suggessted, check your references settings (while in any VBA module, select Tools - References) to see if any are missing. Also try recompiling your code to see if you get any weird errors, which can also indicate a references problem.

[Bo Hansson]

Looking at the references there are eight marked as available, none as missing. I´ve also uninstalled the latest Office 2016 update, but with no effect.