Access Switchboard problem.

G

Guest

I'm running Access2003 on an XP computer, with DirectX 9.0c and using an
Access 2002-2003 file format.

I've built a two form Switchboard that currently accesses two forms, and
will later access more items.

After creating the Switchboard, I try to run it by clicking on the
switchboard form in the forms list. The first time I try I get the following
error:

Run time error '429':
ActiveX component can't create object

If I close the database project, and reopen it, then try to get to the
switchboard from the same method I get a different error:

Compile Error:
Error in loading DLL

Then it opens the code editor and shows an error on the line; where it's
trying to open the table of Switchboard Items, and find the first item for
this Switchboard Page: (In the FillOptions() method).

Set con = Application.CurrentProject.Connection

And the .Connection is highlighted.
 
G

Guest

Is there a Switchboard Items table? If so, have you tried to manually edit
this table?

Also I have run into some problems after splitting the database with the
Switchboard. Moving the Switchboard Items table to the FE fixes it.

If you need to start over, delete both the Switchboard form and Switchboard
Items table first.
 
G

Guest

I do have a Switchboard Items table, and I'm able to edit it.

I've tried deleteing both the form and the table, and remaking them, I
continue to get the same error.

Forgive my lack of knowledge, but what is the 'FE'?
 
G

Guest

FE is an abbreviation for Front End. I forgot the rule about explaining
abbreviations. My bad.

If you open a new database file and try to create a switchboard, does the
same thing happen? If so there is something wrong with your install of Access
or even Office.
 

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

Similar Threads

Access Switchboard error message 1
switchboard problem 4
Access not closing using Switchboard form 3
runtime error 1
SWITCHBOARD 1
I've lost my Switchboard ! 3
Problem with Switchboard Code 2
Switchboard Minimized 4

Top