• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

Access Switchboard: Class not registered

Hi Experts,

10 years ago or so, I wrote a small Access app (single user), that I've used regularly ever since without flaws, where I've also used the Access Switchboard.

For 2 weeks now, i've been getting Class not registered on line
Set con = Application.CurrentProject.Connection

This is using the original Acces built-in switchboard f\code.

Any ideas will be appreciated.
0
APD Toronto
Asked:
APD Toronto
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Anything changed in your system in the last 2 weeks?
Do you compile the code and compact the DB on a regular basis?

Can you tell us a bit about the conditions under which this error occurs?

I have long since abandoned the Access switchboard because of issues like this, and the inherent complexity.
(VBA Code, Dedicated table, Custom form/control Properties Functions, Limited design changes ...etc)
Twice, I got "confident" and tried to "customize" the switchboard, ...both times I lived to regret that decision...

I am sure there may be a simple solution here, ...
But I have never had a situation where the switchboard manager had an advantage over a Menu system I could create my self.
0
 
APD TorontoAuthor Commented:
Just now i did compile, and compact... still same error

2 weeks ago, I was working on another Access file outputting to Excel, the only thing tjhere was that my client has Excel 07 (v.12), and I 10 (v.14), so i Installed 07 on my PC, but it got buggy with 2 Excels, so I removed 07.

I dont knowe if this led to my Switchboard Err.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Looks like you are missing a Reference to ADO ... since the Switchboard uses ADO.

mx
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Jeffrey CoachmanMIS LiasonCommented:
Then this sounds like it may be a "reference" issue.

But this topic is not my specialty...

I am sure another Expert will be along shortly...
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ADO
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I'd run a repair of Office.

"Class not registered" on a regular Access object is more then a reference.

Jim.
0
 
Helen FeddemaCommented:
That old switchboard is way overdue for retirement.  See my Access Archon article on a New Style Main Menu for a more attractive and easier to modify version.  Here is a link for downloading it:

http://www.helenfeddema.com/Files/accarch212.zip

and here is a screen shot:

New Style Main Menu
0
 
APD TorontoAuthor Commented:
I  tried ADO 2.1, 2.8, 6.1 - Same err, but it does compile
0
 
APD TorontoAuthor Commented:
Thank you all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now