ActiveX

[Mark]

Why would I get a message saying ActiveX can't create object?

 

[Clifford Bass]

Hi Mark,

Ummm... Maybe because ActiveX cannot create it? How about giving us
some more information? Error message(s)? What is the object that it cannot
create? Code that causes the error? What you are doing when the error
happens? Other pertinant information?

Clifford Bass

 

[Mark]

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.

 

[Clifford Bass]

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

 

[Larry Daugherty]

Check your references for any marked "missing"

HTH