Switchboard Manager?

[anonymous]

Hi,

I just upsized an application from Access 2002 to SQL
Server 2000. Normally the switchboard comes up with a
list of options, but now I get:

Run-time error '91'
Object variable or With block variable not set

with this line throwing the error:

Set rst = dbs.OpenRecordset(strSQL)

1. Can this be fixed or is the Switchhboard manager not
supported in an ADP?

2. Are they any third party solutions that I can try to
reenable the menu functionality?

 

[MGFoster]

Hi,

I just upsized an application from Access 2002 to SQL
Server 2000. Normally the switchboard comes up with a
list of options, but now I get:

Run-time error '91'
Object variable or With block variable not set

with this line throwing the error:

Set rst = dbs.OpenRecordset(strSQL)

1. Can this be fixed or is the Switchhboard manager not
supported in an ADP?

2. Are they any third party solutions that I can try to
reenable the menu functionality?

The Switchboard Manager uses DAO to handle reading (& writing) to the
Switchboard table. You'll have to set a Reference to the Microsoft DAO
3.6 library in the VBA menu: Tools > References dialog box. There are
some other changes to the Switchboard form that you'll have to do, but I
forget which ones.

 

[Vadim Rapp]

Hello anonymous:
You wrote in conference microsoft.public.access.adp.sqlserver on Sun, 21
Mar 2004 10:02:22 -0800:

a> Hi,

a> I just upsized an application from Access 2002 to SQL
a> Server 2000. Normally the switchboard comes up with a
a> list of options, but now I get:

a> Run-time error '91'
a> Object variable or With block variable not set

a> with this line throwing the error:

a> Set rst = dbs.OpenRecordset(strSQL)

change it to

set rst=currentproject.execute(strSQL)


Vadim

 

[anonymous]

Hi,

Thanks for the pointers.