Thread: ActiveX
View Single Post
  #4  
Old May 21st, 2009, 06:01 PM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default ActiveX

Hi Mark,

Okay, this is helpful for dealing with the error. Let's start with
checking to see if the problem is specific to the one database or happens
regardless of the database. Create a new database and try to create a
switchboard in it. Does that work? If yes, then the problem is specific to
the one database. I am going to assume that that is the case; let me know if
it is not. On that assumption: Try a compact and repair if you have not
already tried it. If that does not help, try a decompile/recompile (see
http://www.granite.ab.ca/access/decompile.htm for details. If that does
not work, check your references to see if any are missing. You will find
them in the VBA Editor under the Tools menu. If any are reported as missing
make a note of them. Then uncheck them and try a compile to see if they are
even needed. If so, go back into the references and see if you can find and
check them, or maybe newer versions of them. If successful, try creating
your switchboard. Does it work? If not, try creating an entirely new
database and importing all of the current database's objects into it. Now
can you create a switchboard?

Hope that helps,

Clifford Bass

"Mark" wrote:

All I'm doing is trying to create a switchboard. I go to Tools-Database
Utilities-Switchboard Manager and I get a "ActiveX component can't create
object". I am new to this but I have done it before without difficulty. I
don't work with Access much at all and I'm asking questions. I don't know if
the system I am trying to do it on has security settings that could cause it
or not.