2003 and 2007 compatibility issue

[Guest]

Hy,

I have Windows XP environment and office 2003 and 2007 is installed.
Last week I had a Access 2003 class and the instructor was doing vba coding
and she would get a object language error. I found out that access 07 uses
object language 12 and 03 uses 11.
Microsoft has some code either in vb or the registry that
automatically goes to object oriented language 12 which is the newest version
of that application. We checked to see if manually we can choose object
language 11 but it was not there, in the references. Can both applications
coexist? Can someone help me out, thanks.

 

[Franck]

it's what you call library, if you right click the file and select
"open with" and if you choose office 2003 itll run with 2003 language
if you choose 2007 itll choose the 2007 one. i saw you write down
about vb ,
if your using vb the references to use are called :
"Microsoft Office 11.0 Object Library" for Office v11.0 (2003)
or
"Microsoft Office 12.0 Object Library" for office v12.0 (2007)

 

[Arvin Meyer [MVP]]

Yes, both can coexist, I have a Vista machine with both of them on it.
Unlike earlier versions, it is really slow to change between them. I suggest
that you open the version that you want to use, of each product that may be
used, before running any application or code.

 

[Sascha Trowitzsch]

Hi,

it's what you call library, if you right click the file and select
"open with" and if you choose office 2003 itll run with 2003 language
if you choose 2007 itll choose the 2007 one. i saw you write down
about vb ,
if your using vb the references to use are called :
"Microsoft Office 11.0 Object Library" for Office v11.0 (2003)
or
"Microsoft Office 12.0 Object Library" for office v12.0 (2007)

I guess Joe ment two things: 1. Reopening a database in A2003 shows up a O12
reference, 2. a O11 reference is not available in references dialog.
This was also reported by some other users with parallel installations.

To do: Open mdb in A2003, open references, uncheck Office 12 and then close the
dialog.
Reopen references, search manually for mso.dll in folder c:\program
files\microsoft shared\office11 and load it to set a reference to it.

Ciao, Sascha

 

[AnandaSim]

Yes, both can coexist, I have a Vista machine with both of them on it.
Unlike earlier versions, it is really slow to change between them. I suggest
that you open the version that you want to use, of each product that may be
used, before running any application or code.

From earliest editions of Microsoft Office Suites in our game, we have

had to have side by side installations of Office and all manner of
niggles would surface. We didn't have a choice in those days other
than to buy another PC or to dual boot separate Windows and Office
from the same hard disk. Nowadays, there's more convenient solutions
like Altiris SVS or Microsoft Virtual PC (both free) so that we less
problems and we don't have to do the side by side thing.

HTH

Ananda