Switchboard generates run time error

[Alex Wills]

Hi

One of our windows XP PC's has stopped running switchboards on Access 2000
databases.

when a switchboard starts the following error is generated

Run-time error 2147024769 (8007007f)
Method 'Connection' of object '_CurrentProject' failed

the line that is giving the problem is
Set con = Application.CurrentProject.Connection

I have tried the DB on other PC's and it works fine, I have also created a
new blank database with a switchboard which gives the same problem.

All the latest updates have been loaded for XP and Office, I have even tried
removing office and re-installing it.

Any thoughts

Thanks
Alex

 

[Sam Hobbs]

I searched the MS KB for 0x8007007f in "- All Microsoft Products -" and got
one result; see:

You receive a "Clip organizer cannot complete operation the specified
procedure could not be found error code 0x8007007f" error message when you
try to insert Clip Art into Publisher 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;884424

So perhaps Access needs to be re-installed. Perhaps there should be
corresponding MS KB article about Access getting this error, or perhaps
there should be a more genearl MS KB article. Perhaps a MS person should
have responded to this question.

Note that 2147024769 <> &H8007007f (I think); 2147942527 = &H8007007f
(right?). Also, "0x8007007f" is the C language syntax that is "&H8007007f "
in VB and the MS KB usually uses the C syntax.

Since "0x8007007f" is not in the KB, one way to get a clue to the problem is
to look up error code 7f (127). I think that is relevant here, and it's
MessageText is "The specified procedure could not be found". However other
than the C-language header file in the Windows SDK, I don't know where to
look for MessageText values. There should be some place in the Microsoft
documentation something about the format of error codes; the following is
for CDO for Windows 2000 but the top portion applies for essentially all
Windows applications and there should be something such as this for all
Windows applications. The relevant portion is essentially copied from the
C-language header file in the Windows SDK.

Error Codes
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_error_codes.asp

 

[Sam Hobbs]

Also see:

5.1.4 Status Values and Exception Codes
http://msdn.microsoft.com/library/d...l/5.1.4_status_values_and_exception_codes.asp

That page is in the Windows NT for Alpha documentation but it appears to be
general enough that it applies to nearly all Windows error codes. When you
see an error code that has "8007" in the first half of the hexadecimal base
error code, the low-order half is almost certainly an error code that is
defined in the SDK header file winerror.h.

The corresponding error description can be retrieved using SDK function
FormatMessage but I don't know what the easiest way is for VB. The following
is my C-language sample of FormatMessage:

http://simplesamples.info/Beginners/FormatMessage.php

 

[Lonnie@arcess4less]

Alex

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.
Lonnie