Access 2003 call to vb4 dll

[JO]

I have a properly-registered dll that needs to open a recordset on a table in
the calling database. My command button call to the dll is based on
Knowledge Base Article 172059.
I've determined (with the use of Msgboxes to stop the compiled dll as it
executes) that the 424 'Object Required' error is caused when I execute the
'OpenDatabase' DAO method inside the dll. Opendatabase is still a valid
method in Access 2003 VBA DAO and tests there very well.
The OpenDatabase method is also still valid in VB6, so I cannot figure out
why my dll has a problem with Access 2003.
Everything works very well in Access 97. The dll does everything it should
there.
Any ideas?
Thanks much in advance.

 

[Douglas J. Steele]

When you created the DLL, what version of DAO did you specify? Access 97
uses DAO 3.5x, Access 2003 (as well as 2000 and 2002) uses DAO 3.6

 

[JO]

The VB4 dll will only compile with DAO 3.0. I went back and tried 3.51 and
3.6 and they each stopped compiling on the rs.Update at the end of a
recordset, showing 'argument not optional'.

 

[Douglas J. Steele]

What's the exact line of code it's complaining about? There were changes
made in DAO 3.5x that may have prevented previously valid code from working.