I have a VB6 app (I'll call it A) which uses it's own Access 2000 file to store data. The app has been in successful use for some time. When I install and then uninstall another VB6 app (I'll call it B) which also works with an Access 2000 database file, A gives a runtime error 438 'Object doesn't support this property or method.' I think this is probably because it can no longer find a required shared file.
By doing some logging, I have determined that the error occurs in the statement:
Set rsQuotes = OpenDatabase("Quotes")
I have tried looking in the Project>Components and in the Object browser to determine precisely what file the code will look for to find this OpenDatabase function. I cannot find it anywhere.
Other sources seem to point to the dao360.dll file, but I still cannot find where my VB6 project specifies what shared file to find it in.
Other info that may be relevant:
The error no longer occurs if I re-install B.
The problem shows up on my XP SP3 test platform on which the only other installed app is MS Office, but does not show up on my development machine with lots of other software installed.
Any advice on how to find out where my VB6 code will look to find the OpenDatabase function in the above code? Any other suggestions on how I might be able to isolate the cause of the error?