2003-2007: Migration?

  • Thread starter Thread starter (PeteCresswell)
  • Start date Start date
P

(PeteCresswell)

Place where I've been serving just announced availability of
Office 2007 for all users.

Seems inevitable that a few of my MS Access 2003 apps will be
affected.

Has anybody migrated?

Gotchas?
 
(PeteCresswell) said:
Place where I've been serving just announced availability of
Office 2007 for all users.

Seems inevitable that a few of my MS Access 2003 apps will be
affected.

Has anybody migrated?

Gotchas?

Make sure that ALL service packs and any applicable hot fixes are applied.
I'd also keep my databases in the MDB format if you expect to use User-Level
Security. As in every migration, test thoroughly before committing anything.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.
 
Has anybody migrated?

I haven't, but started testing this week.

Is it just me, or is Office 2007 just about the ugliest application
on the face of the earth? The chrome is so incredibly obtrusive that
I find it distracting from the documents and databases I'm working
with.

The colors also clash terribly with the most active client app I'm
working on right now, which must happens to use for one of the main
forms a background color of blue that is very similar to the
chrome's blue. It is very distracting to have the chrome be the same
color as the form. Worse still, the two other main forms use
different colors. One is a fairly neutral color, but the other one
clashes really, really badly with the Access chrome. In previous
versions of Access, the chrome was neutral and faded into the
background.

Is there any way to change this? I can't see how I can make any of
my apps look decent in A2007 unless I design them to use the same
color scheme as the Access chrome.

There are themes and such tripe, but is that for your app, or does
it affect the Access chrome, too?

I'm pretty not happy with this aspect of it, while enjoying all the
other neat new things. I'm adapting to the re-arrangement of
features, but not happy with the amount of screen real estate taken
up by the ribbon (minimizing it seems to me to be the only possible
way to work with it). It also seems to me that it foolishly
aggravates the aspect ration problem that is only getting worse as
people start using panoramic monitors -- that is, documents are
tall, but monitors are wide (and getting proportionally wider). The
extra vertical space taken up by the ribbon forces even more
squishing of the forms into a short and wide aspect ratio. This is
not going to work for some of my apps at all.

I haven't yet tried relocating the ribbon to the side -- is that
possible at all? I hesitate to fire it up to check, as it will take
5 years to reconfigure itself, and I have A2003 work to do later,
anyway, so I'd then have to wait on A2003 to reconfigure itself. I
was expecting this, but must say that A2007 takes much, much longer
to reconfigure than any MS app I've ever encountered.
 
I haven't yet tried relocating the ribbon to the side -- is that
possible at all? I hesitate to fire it up to check, as it will take
5 years to reconfigure itself, and I have A2003 work to do later,
anyway, so I'd then have to wait on A2003 to reconfigure itself. I
was expecting this, but must say that A2007 takes much, much longer
to reconfigure than any MS app I've ever encountered.

Service Pack 1 fixes the reconfiguration time. Well, it reduces it from
minutes to about 30 to 40 seconds.
 
Service Pack 1 fixes the reconfiguration time. Well, it reduces it
from minutes to about 30 to 40 seconds.

I patched to SP2 before running it, so that can't be it. My machine
isn't fast, but it's still pretty ridiculous. I just checked Excel
2007 to see if it's SP2, and it is (though I had to Google on where
to find the ABOUT box!).
 
``
David W. Fenton said:
I patched to SP2 before running it, so that can't be it. My machine
isn't fast, but it's still pretty ridiculous. I just checked Excel
2007 to see if it's SP2, and it is (though I had to Google on where
to find the ABOUT box!).
 
Back
Top