2007 Installation

[judith]

I have a new machine with Vista and loaded Office 2002 followed by Office
2007 in separate folders but I can no longer run my 2002 access files. When i
open them in 2002 i get a series of messages
..... object or class does not support the set of events ....
I then unloaded Access 2007 but left the rest of Office 2007. When opening
the file in 2002 it did a repair and the all was fine. I reload 2007 and am
back to the same problem.
If I open a file in 2007 I get the same error message although after a bit
of persistance I can open the odd application but not all of them.

Is this a Vista problem or Access and any suggestions for getting round it
please. I have 3 other machines with combinations of Office 97, 2000, 2002
and 2003 loaded and have never had any problem before

 

[Graham R Seach]

Judith,

As I understand it, it's an Office 2007 issue. My recommendation is to
install one version in a Virtual PC session.

You can download Virtual PC 2007 from Microsoft at the following URL:
http://www.microsoft.com/downloads/...02-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[judith]

I am rather hesitant ... the site does not really give much in the way of
details about how it will look or operate. Also I dont want to load different
OS versions just Office and only access at that. Do you think that this
problem is likely to be fixed in the near future as I can survive with
loading and unloading for the time being and would like to preserve my new
machine without too many fixes and patches.
Thanks for the info though and will try it if there is no patch from
Microsoft soon

 

[Graham R Seach]

Judith,

Firstly, Vrtual PC is a mature product, so installing it is no problem,
except that it is resource hungry (as one would expect). Many many people
use it on a daily basis; me included. On my Vista Ultimate laptop, for
example, I have Office 2007 installed under Vista, but have Office 2003
installed under Windows XP in a Virtual PC 2007 instance.

Install Virtual PC, install an operating system under it, then install
Office under that. It will behave exactly as you would expect any
installation to behave.

I can't say whether things will change in a later version, but I doubt that
a patch will fix this problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[judith]

Graham

A whole load more questions if you have the patience. Do i need to install a
different OS or can i just have the virtual PC running Vista as well. Then I
could load just office 2007 including access and leave the main part of the
machine with Office 2007 minus access plus back loads. Is it easy to flip
from one to another, is it like switching users. Can I leave files loaded in
one while switching to the other. Also do I need a further licence if i
decide to load Windows XP to the virtualP C?

You have given me the confidence to try it anyway, thanks

 

[JeffK]

Judith,

I encountered the exact same problem after installing Access 2007 alongside
Access 2002. Please see the following discussion on utteraccess, where Clint
Covington from the Office group was able to help me come up with a solution.

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1348545&page=&view=&sb=5&o=&fpart=1&vc=1

The discussion is quite long, so I'll try to summarize. This is not a bug,
but an unfortunate side effect of the change to the underlying object class
modules in the new version. My case involved a withevents form variable
being set to an open access form. The code was running in an mde compiled in
the 2002 application, meaning that even when I opened the database in 2007,
the library used to declare the form variable was 2002 because of the
pre-compiled mde. But, the new version of the Access form class implements a
new set of events so when I try to set the 2002-compiled form variable to an
Access 2007 form, I got the "Object does not support this set of events"
error.

The solution is to compile the 2002 mdb into an mde using the 2007
application, which then saves the 2007 Access library as part of the mde.
The library is still a 2002 database format, but can be compiled in the 2007.
This would of course be a problem for users still running Access 2002 who
want to use the mde. However, I have an exe that opens an Access "portal"
app for my users that directs them to other databases. So, I keep one
version of the library compiled under the 2002 application and one compiled
under the 2007 application. The exe checks to see what version of Access is
running and copies the appropriate library to the user's computer as the same
file name before running the front-end application. It works perfectly.

Now if we could only get those other bugs fixed....

 

[JeffK]

I'm sorry it was Rob Cooper, who helped me with this one... so many Access
2007 questions...

 

[Graham R Seach]

Judith,

<<Do i need to install a different OS or can i just have the virtual PC
running Vista as well.>>
You can install whatever OS you want.

<<Is it easy to flip from one to another>>
It's as easy as Ctrl + Enter

<<Can I leave files loaded in one while switching to the other.>>
Yes.

<<do I need a further licence if i decide to load Windows XP to the
virtualPC?>>
To be honest, I'm not sure of the licensing issues there. It would certainly
be worthwhile asking the question in a new thread. I don't *think* it would
be a problem, but I'm no licensing expert.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Scott McDaniel]

<<do I need a further licence if i decide to load Windows XP to the
virtualPC?>>
To be honest, I'm not sure of the licensing issues there. It would certainly
be worthwhile asking the question in a new thread. I don't *think* it would
be a problem, but I'm no licensing expert.

I'm not either, but when I installed vmWare (same thing as VPC) the literature I dug up indicated you must have a
license for EACH installation of the OS. When I first installed vmWare, I used my copy of XP (the one on my dev machine)
to install to the virtual machine, and when it attempted to activate I was alerted that the number was already in use.
I've got an MSDN subscription, so I just got a new number from there, but that indicated to me that the activation
servers treat the virtual machines as different machines ... of course, I could very well be wrong about this (wouldn't
be the first time <g>).

Note that MS has the Action Pac availble for MS Partners, which includes some OS and Office software and product keys:
https://partner.microsoft.com/40016455 ...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Tony Toews [MVP]]

I have a new machine with Vista and loaded Office 2002 followed by Office
2007 in separate folders but I can no longer run my 2002 access files. When i
open them in 2002 i get a series of messages
.... object or class does not support the set of events ....
I then unloaded Access 2007 but left the rest of Office 2007. When opening
the file in 2002 it did a repair and the all was fine. I reload 2007 and am
back to the same problem.

This is interesting. I was happily running A2007 and A2003 for a
while on the same MDB with no problems. (Unfortunately I ran into a
bizarre A2007 startup problem but that's different.)

What were your references in A2002 and A2007?

Sub ListReferences()

Dim ref As Reference

For Each ref In Application.References

Debug.Print ref.Name & ", " & ref.FullPath & ", " & ref.Major
& "." & ref.Minor

Next

End Sub

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/