Problems with Switchboard in Access 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debbie - 27 Jan 2004 23:28 GMT

Is there any product upload available which will allow my
switchboard to work in 97 after conversion from 2000?
Whenever I convert my file from 2000 and attempt to open
the switchboard in 97 I get a visual basic object error.
I am assuming that I am running too early a version of VB
but I thought 97 when installed with the add-in could run
a switchboard. Confused!

Reply to this Message

GVaught - 28 Jan 2004 04:37 GMT

Since your database was originally 2000 and you converted it down. You need
to fix some references that 97 doesn't have. 2000 uses DAO 3.6 or ADO 2.1 or
higher. 97 uses DA03.51 and no ADO. Open your database by highlight it
first, hold down the shift key and then double click the db file. This will
bypass any opening startup code. Click on any form and then open the 'code'
icon on you toolbar menu (aqua/yellow/red). This will put you into the code
editor. Open up Tools | References. Fix any missing references. Debug |
Compile after fixing the references. Then try your Switchboard.

> Is there any product upload available which will allow my
> switchboard to work in 97 after conversion from 2000?
[quoted text clipped - 3 lines]
> but I thought 97 when installed with the add-in could run
> a switchboard. Confused!

Reply to this Message

Van T. Dinh - 28 Jan 2004 10:23 GMT

I think it may be easier to delete the Switchboard Form retaining the
[Switchboard Items] Table and simply re-create the Switchboard Form using
the Switchboard Manager.

Signature

HTH
Van T. Dinh
MVP (Access)

Reply to this Message