Database problems in Vista

[Pete]

I have been using a database on my XP machine with Access 2007 without
problems but when I run it on my Vista machine I cannot make any of the
buttons on the switchboard work - I get the message:

"The expression On Click you entered as the event property setting produced
the following error: Object or classs does not support the set of events!"

I can run all the queries, forms etc from the database window. Is there
something I need to do to make the switchboard buttons work?

 

[Allen Browne]

See:
http://allenbrowne.com/bug-17.html

Option 2 is probably the best general solution.

 

[Pete]

I tried altering the registry entry and creating a shortcut and selecting
Run as Administrator but unfortunately neither works. I guess I'll have to
run the database in a Virtual Machine, something I wanted to avoid.

 

[Pete]

Further to my last posting, on checking Library References I find that
Microsoft Office 11.0 Object Library is not shown at all and on trying to
re-register it i get the error message:
"C:\Program Files\........\MSACC.OLB was loaded but the entry-point
DllRegisterServer was not found. Make sure that MSACC.OLB is a valid dll or
OCX file and then try again".

Not sure it this is relevant but I installed only Access 2003 from
Office2003.

 

[Allen Browne]

Which references do you have selected?

Are any marked as "MISSING"?

 

[Pete]

Selected references are:
Visual Basic for Applications
Microsoft Access 12.0 Object Library
Microsoft DAO 3.6 Object Library
Microsfot Forms 2.0 Object Library
Microsoft Calendar Control 11.0
OLE Automation
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft Office XP Web Components

I don't see anything marked as MISSING.

 

[Tony Toews [MVP]]

Microsfot Forms 2.0 Object Library

The above is a bit unusual.

Microsoft Calendar Control 11.0

I'd avoid that one given distribution problems.
See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

Microsoft Visual Basic for Applications Extensibility 5.3

Likely not needed but some minor adjustments may be required after
removing.

Microsoft Office XP Web Components

Almost certainly not required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Pete]

Do I simply uncheck all these if not required?

The above is a bit unusual.


I'd avoid that one given distribution problems.
See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm


Likely not needed but some minor adjustments may be required after
removing.


Almost certainly not required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tom Wickerath]

Hi Pete,

First, save a backup copy of your database. Then uncheck one reference at a
time. Click on the OK button to dismiss the References dialog. Then compile
your VBA code (Debug > Compile ProjectName in the VBA editor for Access 2003
and prior). If your code compiles without an error, then the reference was
not needed. If the option to compile appears "greyed" out immediately after
compiling, then your code compiled successfully.

It is always best to "starve" the references list (ie. only include a
checked reference if it is absolutely necessary). Not only will you avoid
loading unnecessary libraries into RAM memory each time your application is
started, but you will also minimize the chances of encountering a missing
reference problem. Here are two excellent articles that provide more
information on this topic:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


As for the reference to the Microsoft Forms 2.0 Object Library, I have seen
this one on occasion. However, every time I have seen it, and attempted to
uncheck it, Access squaks and refuses to let me deselect it. The solution is
to create a new database, and import all objects from the source DB to your
new DB.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Allen Browne]

Pete. you do have the problem I referred you to in my original reply.

Office 2003 is internally called version 11.

The fact that your application is trying to reference:
Microsoft Access 12.0 Object Library
is exactly the problem displayed in the screenshot at:
http://allenbrowne.com/bug-17.html

 

[Pete]

Hello Allen

Thank you for taking the trouble to help me out.

I appreciate that the problem is similar to the one in the screenshot. I
tried Option 1 and 2 in your article but unfortunately the problem did not
go away. As I mentioned below, Office 11 Object Library does not appear at
all in the list of references and on trying to install it I get an error
message.

I wonder if uninstalling both Office 2003 & 2007 and then reinstalling
Office 2003 would solve the problem.

 

[Allen Browne]

Try just uninstalling and reinstalling Office 2003.

I don't think installing Office 2007 will help (unless you need it, of
course.)

 

[Pete]

Thanks for your help

The above is a bit unusual.


I'd avoid that one given distribution problems.
See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm


Likely not needed but some minor adjustments may be required after
removing.


Almost certainly not required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/