If DAO 3.0 is not installed and you use the following line of code:
Set x = CreateObject("DAO.DBEngine")
you will receive the error message described in the "Symptoms" section.
NOTE: This line of code will successfully create, without error, a DAO 3.0object if DAO 3.0 is installed on your computer.
With DAO 3.0, the object name is "DAO.DBEngine" and with DAO 3.5, theversion provided with Microsoft Excel 97, the object name has changed to"DAO.DBEngine.35". So, if you have DAO 3.5 installed, the following line ofcode will create, without error, a DAO 3.5 object:
Set x = CreateObject("DAO.DBEngine.35")
Since the object names for DAO 3.0 and DAO 3.5 are different, it isrecommended that you avoid using CreateObject altogether with DAO for yourcode to be compatible with both versions of DAO.
Instead of using CreateObject to use DAO in your macro, check theappropriate Data Access Object Library in the References dialog box:
With a module sheet active, click References on the Tools menu.
Check the "Microsoft DAO <x.x> Object Library" (where <x.x> is the DAO version) and click OK.
Steps to Determine What Version of DAO is Referenced
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites: