Migrating to Access 2007

[Jim Hess]

I have a database application that over the years has migrated from DOS to an
Access application. I started with Access 97 and so far it has been migrated
as far as Access 2003. My manager has had to upgrade to Access 2007 for some
other things he is doing and has asked me to look into migrating the
application to Access 2007 for everyone. I have it at home. And I have done
a little bit with it. My problem is that I have custom menus and toolbars
that I cannot figure out how to modify with Access 2007. I'm asking if there
is a good book for application development in Access that any of you can
recommend. We have been using this program now for about 13 years in various
versions of Access. I'm close to retiring in the next year or two and don't
want to have to devote a lot of rethinking in my development process. So if
any of you have any good books to recommend I would certainly appreciate
hearing from you.

 

[Albert D. Kallal]

My problem is that I have custom menus and toolbars
that I cannot figure out how to modify with Access 2007.

You can convert your menu bars to macro menu bars. That would modification
of them quite a bit easier in 2007.

How to do this is explained here:

http://office.microsoft.com/en-us/access/HA102825091033.aspx?pid=CH100621911033

The above works in both 2003 and 2007....

You can also continue to develop in a2003, but deploy the mdb to 2007 and
you menus will work.

However, I think I would bite the bullet, and simply convert your menus to
ribbons. I am betting that you likely only have about 2-5 custom menu bars,
and that not really very much. There is tons of articles on ribbons, and
really in one afternoon you up to speed.

As for books, hum, I don't have a great list, but here some other
references:

http://www.accessmvp.com/JConrad/accessjunkie/resources.html#Books

 

[Jim Hess]

Thank you for the reference to those instructions. I have read through them,
but I must say that is a pretty lame process to have to go through. Maybe
I'm just getting too old. But the methods that were in previous versions
were so much simpler. I really don't like the development environment of
Access 2007.

Fortunately, the application that I am maintaining in Access 2003 will run
the new version, so 2003 will remain my development environment. I'm only a
year or two from retirement, and I'm not in the mood to have to learn new
methods. Thanks again for the reference.