MS ACCESS Switchboard Runtime Error 3001

[Steve Meadows]

I get the subject error when I try to add a switchboard to
a new database created using the Access wizard. The
message says invalid argument. The code line is: rs.Open
stSql, con, 1 ' 1 = adOpenKeyset . I have v9.0.6926 SP-
3, VBA V6.03. Does anyone have a solution to this one?
Thanks
Steve

 

[aptech]

why don't you create a new switchboard by urself in design
view instead of using the wizard?

its easy.

 

[Steve]

I usually do. However, I first got this message when I
tried to "load" in my Access an existing db created (BTW,
without this error) on another user's computer also with
access 2K. In my attempt to debug this, I found that my
Access burped on creating one with the wizard, thus
prompting my first post. I could re-invent the
switchboard wheel, but you know, gotta save the taxpayers
some $'s. Or not??

 

[Greg Bromage]

Hi there!

Hop in to Tools - References and check the version of
Microsoft ActiveX Data Objects Library.

I've got Version 2.1 and Switchboard works fine.

I've worked for taxpayers too, so I know about saving the
$$$. :-( The default Switchboard works fine for 80% of
cases, my main complaint about it is that there's no
security mechanism built in there.

Rgds,
Greg