By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

AccXP Dead Switchboard

P: n/a
Hi all,

My computer has suddenly decided that it doesn't like the switchboard - it's
quite happy to open up on other machines, meaning the database itself isn't
at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found a
different database gives me this error in a window titled Microsoft Visual
Basic instead of a switchboard (an earlier version of the same database),
and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz
Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
I believe you may have a missing reference. Open any module in your database (create a
new one if need be). Then click on Tools > References. Make sure that none of them are
marked as MISSING in all caps. If any reference is missing, make a note of which one it
is, deselect it, and click on OK to dismiss the references dialog box. Click on Debug >
Compile to see if your code compiles properly. (You might be missing a reference that you
didn't need to have checked). If you deselected a reference marked as missing, and your
code will not compile, then go back into the references dialog and select that reference
again in the list. Repeat the process of closing the references dialog box and attempting
to compile your code.

You should have a reference to the ADO library checked. It will read as follows:

"Microsoft ActiveX Data Objects 2.x Library"

where x represents the minor version number (2.1, 2.5, 2.6, etc.). If this reference is
not included, then make sure to select it.
______________________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message news:bo**********@sparta.btinternet.com...
Hi all,

My computer has suddenly decided that it doesn't like the switchboard - it's
quite happy to open up on other machines, meaning the database itself isn't
at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found a
different database gives me this error in a window titled Microsoft Visual
Basic instead of a switchboard (an earlier version of the same database),
and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz

Nov 12 '05 #2

P: n/a
Tom,

Thanks for contacting me - I've tried as you suggested and all references
are present and correct, including the ADO, it compiles correctly but still
will not open the switchboard. I've even tried re-installing access!!

Any thoughts?

Barry
Nov 12 '05 #3

P: n/a
Hi Barry,

Is your switchboard form unbound (ie. no recordsource) or based on a bound form (ie.
Switchboard Wizard type switchboard)? When you stated "it's quite happy to open up on
other machines", were you testing the same copy of the .mdb file, or were you testing a
previously delivered copy of the front-end (same .mdb file, but different physical copy)?

Perhaps try "refreshing" the references too. Sometimes there can be a problem finding a
reference, but it will not show up as MISSING. Select any new reference, click OK to
dismiss the dialog, then go back in and deselect the reference. This process will refresh
all checked references.

Have you tried the decompile switch? Have you tried importing all objects into a new DB
container?

I'll take a look at it for you, if you wish to send me a copy of your database. You can
delete all records from the tables (except the "Switchboard Items" table, if you are using
the wizard-built switchboard). Compact & zip please if you want to send it to me.

Tom
_______________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message
news:bo**********@hercules.btinternet.com...
Tom,

Thanks for contacting me - I've tried as you suggested and all references
are present and correct, including the ADO, it compiles correctly but still
will not open the switchboard. I've even tried re-installing access!!

Any thoughts?

Barry


Nov 12 '05 #4

P: n/a
"Baz'noid" <ba***@rtd.uk..com> wrote in news:boihb7$852$1
@hercules.btinternet.com:
Tom,

Thanks for contacting me - I've tried as you suggested and all references
are present and correct, including the ADO, it compiles correctly but still
will not open the switchboard. I've even tried re-installing access!!

Any thoughts?

Barry


The kb article at
http://support.microsoft.com/default...b;en-us;307255
may pertain tho this problem.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #5

P: n/a
Very strange....I just used the MessageText function, shown in KB article 186063,
http://support.microsoft.com/default.aspx?kbid=186063

on the error number you indicated below. I am not getting the same return. I get the
following message returned in the debug window:

?MessageText(-2147024769)
The specified procedure could not be found.

__________________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message news:bo**********@sparta.btinternet.com...

Hi all,

My computer has suddenly decided that it doesn't like the switchboard - it's
quite happy to open up on other machines, meaning the database itself isn't
at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found a
different database gives me this error in a window titled Microsoft Visual
Basic instead of a switchboard (an earlier version of the same database),
and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz

Nov 12 '05 #6

P: n/a
I previously posted on the 5th about a similar problem:

++
Beginning yesterday, all Access 97 apps run fine on one computer, but on
another computer, ALL Access 97 apps give the following error when Autoexec
is executed:

"The expression you entered has a function name that Microsoft Access can't
find"

(1) no changes to installed software on either computer
(2) its the same MDB on both computers
(3) the offending computer never sees the internet
(4) the one function that Autoexec calls does exist, and works on the other
computer
(5) on the offending computer, the above message is displayed and the
function: StartUp() is never executed ( a breakpoint set on the first line
of StartUp() is never hit )
++

The os is win2k and reinstalling access did not help. I read the kb
suggested in this thread and it sounds like I will have to wipe the drive
and reinstall everything.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:mq********************@comcast.com...
Very strange....I just used the MessageText function, shown in KB article 186063, http://support.microsoft.com/default.aspx?kbid=186063

on the error number you indicated below. I am not getting the same return. I get the following message returned in the debug window:

?MessageText(-2147024769)
The specified procedure could not be found.

__________________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message news:bo**********@sparta.btinternet.com...
Hi all,

My computer has suddenly decided that it doesn't like the switchboard - it's quite happy to open up on other machines, meaning the database itself isn't at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found a
different database gives me this error in a window titled Microsoft Visual
Basic instead of a switchboard (an earlier version of the same database),
and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz

Nov 12 '05 #7

P: n/a
Hi John,

Here is another KB article for you to check as a possibility. The third error message
listed matches the one you provided below, and results when using the RunCode action in a
macro:

ACC: Same Named Module and Function Cause Error After Conversion
http://support.microsoft.com/default...b;en-us;148529

You stated "no changes to installed software on either computer", but could there have
been a change made to the database itself? In particular, could one of your procedures
(ie. a subroutine or function) have the same name as one of your modules? Note that your
code will still compile without a problem.

Another possibility is listed in this KB article:

ACC97: Cannot Call Class Module Methods from Microsoft Access Objects
http://support.microsoft.com/default...b;en-us;170532
Tom

____________________________________________

"xzzy" <mr********@comcast.net> wrote in message
news:8lcrb.146019$HS4.1183456@attbi_s01...
I previously posted on the 5th about a similar problem:

++
Beginning yesterday, all Access 97 apps run fine on one computer, but on
another computer, ALL Access 97 apps give the following error when Autoexec
is executed:

"The expression you entered has a function name that Microsoft Access can't
find"

(1) no changes to installed software on either computer
(2) its the same MDB on both computers
(3) the offending computer never sees the internet
(4) the one function that Autoexec calls does exist, and works on the other
computer
(5) on the offending computer, the above message is displayed and the
function: StartUp() is never executed ( a breakpoint set on the first line
of StartUp() is never hit )
++

The os is win2k and reinstalling access did not help. I read the kb
suggested in this thread and it sounds like I will have to wipe the drive
and reinstall everything.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:mq********************@comcast.com...
Very strange....I just used the MessageText function, shown in KB article 186063, http://support.microsoft.com/default.aspx?kbid=186063

on the error number you indicated below. I am not getting the same return. I get the following message returned in the debug window:

?MessageText(-2147024769)
The specified procedure could not be found.

__________________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message news:bo**********@sparta.btinternet.com...
Hi all,

My computer has suddenly decided that it doesn't like the switchboard - it's quite happy to open up on other machines, meaning the database itself isn't at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found a
different database gives me this error in a window titled Microsoft Visual
Basic instead of a switchboard (an earlier version of the same database),
and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz


Nov 12 '05 #8

P: n/a
"Tom Wickerath" <AO***********************@comcast.net> wrote in message news:<uL********************@comcast.com>...
Hi John,

Here is another KB article for you to check as a possibility. The third error message
listed matches the one you provided below, and results when using the RunCode action in a
macro:

ACC: Same Named Module and Function Cause Error After Conversion
http://support.microsoft.com/default...b;en-us;148529

You stated "no changes to installed software on either computer", but could there have
been a change made to the database itself? In particular, could one of your procedures
(ie. a subroutine or function) have the same name as one of your modules? Note that your
code will still compile without a problem.

Another possibility is listed in this KB article:

ACC97: Cannot Call Class Module Methods from Microsoft Access Objects
http://support.microsoft.com/default...b;en-us;170532
Tom

____________________________________________

"xzzy" <mr********@comcast.net> wrote in message
news:8lcrb.146019$HS4.1183456@attbi_s01...
I previously posted on the 5th about a similar problem:

++
Beginning yesterday, all Access 97 apps run fine on one computer, but on
another computer, ALL Access 97 apps give the following error when Autoexec
is executed:

"The expression you entered has a function name that Microsoft Access can't
find"

(1) no changes to installed software on either computer
(2) its the same MDB on both computers
(3) the offending computer never sees the internet
(4) the one function that Autoexec calls does exist, and works on the other
computer
(5) on the offending computer, the above message is displayed and the
function: StartUp() is never executed ( a breakpoint set on the first line
of StartUp() is never hit )
++

The os is win2k and reinstalling access did not help. I read the kb
suggested in this thread and it sounds like I will have to wipe the drive
and reinstall everything.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:mq********************@comcast.com...
Very strange....I just used the MessageText function, shown in KB article

186063,
http://support.microsoft.com/default.aspx?kbid=186063

on the error number you indicated below. I am not getting the same

return. I get the
following message returned in the debug window:

?MessageText(-2147024769)
The specified procedure could not be found.

__________________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message

news:bo**********@sparta.btinternet.com...

Hi all,

My computer has suddenly decided that it doesn't like the switchboard -

it's
quite happy to open up on other machines, meaning the database itself

isn't
at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found a
different database gives me this error in a window titled Microsoft Visual
Basic instead of a switchboard (an earlier version of the same database),
and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz

People

I am an amateur in database development or any programming however
offer the following.
A while ago I experienced this problem (in my case the message was the
missing function name one).
The switchboards would not open on any .mdb data base on my machine
(my machine: Windows 98 OS and Office XP)however on another machine on
my network (Windows XP OS and Office XP) there were no problems
(completely seperate copies of each .mdb on each machine).
In desperation I reinstalled Windows 98 on my machine and the problem
has not surfaced again.

Regards
Nov 12 '05 #9

P: n/a
Curious to know if the problem started after installing MS Money?

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Tom Watson" <tr*********@bigpond.com> wrote in message
news:87**************************@posting.google.c om...
"Tom Wickerath" <AO***********************@comcast.net> wrote in message

news:<uL********************@comcast.com>...
Hi John,

Here is another KB article for you to check as a possibility. The third error message listed matches the one you provided below, and results when using the RunCode action in a macro:

ACC: Same Named Module and Function Cause Error After Conversion
http://support.microsoft.com/default...b;en-us;148529

You stated "no changes to installed software on either computer", but could there have been a change made to the database itself? In particular, could one of your procedures (ie. a subroutine or function) have the same name as one of your modules? Note that your code will still compile without a problem.

Another possibility is listed in this KB article:

ACC97: Cannot Call Class Module Methods from Microsoft Access Objects
http://support.microsoft.com/default...b;en-us;170532
Tom

____________________________________________

"xzzy" <mr********@comcast.net> wrote in message
news:8lcrb.146019$HS4.1183456@attbi_s01...
I previously posted on the 5th about a similar problem:

++
Beginning yesterday, all Access 97 apps run fine on one computer, but on
another computer, ALL Access 97 apps give the following error when Autoexec is executed:

"The expression you entered has a function name that Microsoft Access can't find"

(1) no changes to installed software on either computer
(2) its the same MDB on both computers
(3) the offending computer never sees the internet
(4) the one function that Autoexec calls does exist, and works on the other computer
(5) on the offending computer, the above message is displayed and the
function: StartUp() is never executed ( a breakpoint set on the first line of StartUp() is never hit )
++

The os is win2k and reinstalling access did not help. I read the kb
suggested in this thread and it sounds like I will have to wipe the drive and reinstall everything.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:mq********************@comcast.com...
Very strange....I just used the MessageText function, shown in KB article
186063,
http://support.microsoft.com/default.aspx?kbid=186063

on the error number you indicated below. I am not getting the same

return. I get the
following message returned in the debug window:

?MessageText(-2147024769)
The specified procedure could not be found.

__________________________________________

"Baz'noid" <ba***@rtd.uk..com> wrote in message

news:bo**********@sparta.btinternet.com...

Hi all,

My computer has suddenly decided that it doesn't like the
switchboard - it's
quite happy to open up on other machines, meaning the database itself

isn't
at fault, it must be something wrong on my machine.

It just doesn't open anymore. Can't figure out why, but i have found

a different database gives me this error in a window titled Microsoft Visual Basic instead of a switchboard (an earlier version of the same database), and I'm hoping it's related and someone here will know what to do.....

Run-time error '-2147024769 (8007007F)':

Method 'Connecton' of object '_CurrentProject' failed

Help?!?

Baz

People

I am an amateur in database development or any programming however
offer the following.
A while ago I experienced this problem (in my case the message was the
missing function name one).
The switchboards would not open on any .mdb data base on my machine
(my machine: Windows 98 OS and Office XP)however on another machine on
my network (Windows XP OS and Office XP) there were no problems
(completely seperate copies of each .mdb on each machine).
In desperation I reinstalled Windows 98 on my machine and the problem
has not surfaced again.

Regards

Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.