APD Toronto
asked on
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 .Connectio n
This is using the original Acces built-in switchboard f\code.
Any ideas will be appreciated.
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
This is using the original Acces built-in switchboard f\code.
Any ideas will be appreciated.
ASKER
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.
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.
Looks like you are missing a Reference to ADO ... since the Switchboard uses ADO.
mx
mx
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...
But this topic is not my specialty...
I am sure another Expert will be along shortly...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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:
http://www.helenfeddema.com/Files/accarch212.zip
and here is a screen shot:
ASKER
I tried ADO 2.1, 2.8, 6.1 - Same err, but it does compile
ASKER
Thank you all.
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.