Running Access 2007 In Office 2003

[Rich Locus, Logicwurks, LLC]

Hello:
I reviewed about 20 posts from a search, and none were identical to my
question, which is very simple:

With a system that has Office 2003 (without Access 2003), can I install
Access 2007 and use it with no issues with existing 2003 Office products?

Thanks,
Rich Locus
Logicwurks, LLC

 

[Allen Browne]

If you already have Access 2003 on your computer, you can do a custom
install of Access 2007, and instruct it not to remove Access 2003. (The
default install will remove it.)

You can then use each version of Access separately. Lots of us do that
(supporting clients on different versions), but there are a few gotchas,
e.g.:

a) Whenever you switch version, it takes a few moments to "install".

b) You mustn't run different versions at the same time. The libraries won't
be registered properly, and so a new database you create will have mongrel
versions.

c) Keep your library references to a minimum. If you use additional library
references, they may not work correctly across versions. It's fine if you
restrict yourself to the basic three:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


"Rich Locus, Logicwurks, LLC" <Rich Locus, Logicwurks,
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Rich Locus]

Allen:
Your referenced article on libraries was very helpful. Since I don't
already have Access 2003 on the my target system but just the other Office
2003 products, I wouldn't think there would be many of the issues you
mentioned in your article for having multiple versions of Access on the same
system. Since I do use MSCAL.OCX, I will make sure that my Access 2007
install doesn't nuke the version I use for Excel 2003.

Thanks,

 

[Douglas J. Steele]

Unfortunately, shared libraries are not necessarily specific to Access. In
fact, problems with shared libraries can even be caused by non-Microsoft
products.

In other words, Allen's advise is probably still relevant even in your
situation.