My customer has uninstalled Office Professional 97 and installed Office
Professional 2000.  She has opened an existing Access database and at
the prompt re converting she elected to convert to 2000.  The database
was secure and had a switchboard.  The database would not work. None of
the wizards work.  None of the buttons on the switchboard worked.  The
user removed security and created a new Access 2000 database.  She
imported all the tables, forms (except the switchboard) and queries from
the original database.  On attempting to create a switchboard and use
the buttons the computer hangs.    She has attempted compact and repair,
it compacts then a message appears in status bar "Command button
wizard".  PC hangs.  Fortunately the user has a backup copy.  Have tried
recreating again by importing all except the switchboard from the
unsecured 97 database, it works for a while then some time after adding
the switchboard it fails.  Any ideas?

Jean Stretton

By default, A '97 uses DAO references.  By default, A2K uses ADO references.
If there are any "Dim xxx as database", or "Dim yyy as recordset" in the
application, A2K is assuming you want ADO.  Your user will need to
explicitly set a reference to DAO, and move it above the ADO reference.  If
there are no ADO calls, it can be unchecked.

Open a module, select Tools | References and check/uncheck appropriately.

Good luck

Jeff Boyce
<Access MVP>