Problems with Switchboard in Access 97

D

Debbie

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!
 
G

GVaught

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.
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top