Opening Main Switchboard failed

[TomL]

having created a database and a main switchboard, i tried to open the
switchboard but failed with the following error message "Run-time error
'-2147024769 (8007007f)': Method 'Connection' of object '_CurrentProject'
failed".
The line highlighted by the debugger is :
Set con = Application.CurrentProject.Connection.

Question is, how do i fix this?

 

[mnature]

I'm having the same problem. My database front-end runs on three other
computers, but fails on a fourth computer. I can see the server files from
that computer, but seems that switchboard is causing failure on opening the
database.

I tried upgrading the MDAC on that computer, but it did nothing.

 

[Lonnie@arcess4less]

If you have not got this one figured out yet then use this link and install
MDAC 2.8

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Worked for me on a computer running XP and Access 2000.
Lonnie

 

[mnature]

OK, there could be a fix for this, but it is not pretty. Only works for a
computer running XP, SP2. If XP has been upgraded to SP2, as opposed to a
clean install of XP SP2, then the only way to load in the files that are
required by Access is to uninstall SP2, and then reinstall it. Well, I
suppose you could do a reformat, and then do clean install of XP SP2. The
MDAC files don't upgrade properly the first time SP2 is installed. You would
have to ask Microsoft why they load properly if the SP is uninstalled, and
then reinstalled. Also, you cannot just install SP2 a second time, has to be
uninstalled and reinstalled.