View Single Post
  #2 (permalink)  
Old September 29th, 2003, 02:41 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Hi Sam,

If you decide to convert your DAO to ADO you'll need to do it manually. The conversion is, of course, completely unnecessary as you've already discovered, unless you just want the practice of working with ADO, or you are planning on upgrading to a SQl Server backend someday. If you have a copy of VB6 lying around, here is a project you can download that does a side-by-side comparison of all the major DAO/ADO objects, and demonstrates how to convert between them. Go to: and search for "Migrating From DAO to ADO."

Finally, if you're trying to create a custom commandbar named "correspondence log", try using:

Set CmdBar = CommandBars.Add("correspondence log")

The Add method will create the new commandbar by adding it to the commandbars collection.