migrating from access 2002 to 2007

aeolianje
aeolianje used Ask the Experts™
on
We will be migrating from Windows XP to Windows 7 in a few months.  We have several MS Access applications that were developed in access 2002.  They seem to run ok in the Win 7 test environments but there are noticeable differences for the user.

Any ideas on how to make the apps more transparent during this migration?

Some of the things I've noticed so far:
- pop-up messages at startup (any way to bypass?)
- ribbons
- custom menus (some show along with the ribbons, others don't)
- references change

I'm still testing...

Thanks,
je
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Popup messages - add the folder where the Access app resaides to the trusted locations Use the Office gizmo at the top right and select Access settings from the bottom of the menu and follow your nose.

Ribbons - a fact of life for 2007 and beyond. There is a download for 2007 that adds the old 2003 menus in if you really have to.

Custom Menus - plan to redevelop into custom ribbons

References - shouldn't be too much of an issue as moving to a lter one is fairly automatic.

Other issues - you need to get used to the new database window (probably won't afffect the users). Custom shortcut menus (right click menus) cannot be edited in 2007 and beyond.

There is an add in for 2007 that allows printing of reports to pdf without the need for 3rd party software.

Kelvin
You don't have to upgrade to 2007.   The 2002 database can be run as a 2002 database.
Yes, you can leave them as mdb's, but you're still left with the ribbon, trusted locations, new database window.....

No need to upgrade to accdeb, unless you want to make use of any features introduced in 2007. If I were migrating, I'd be looking to go with Access 2010 rather than 2007. Is a tidier package, but you've still got all those issues!!
Office 2002 can run in the Windows 7 operating system.   My point is the databases can be run in an Access 2002 environment until they can be converted.   Windows 7 upgrade and operating issues do not need to be compounded with Access conversion issues.
I agree, too.  That moving to Office 2010 makes more sense than an upgrade to Office 2007.  But, we don't know the licensing environment.

Author

Commented:
ok -- I'm not being clear.  The 2002 apps will run.  But with Win 7 the runtime version of Access will be upgraded to 2010.  I'm hoping to resolve any potential issues ahead of time.

Thanks,
je
Are you going run them as mdb's (unconverted) or accdbs (converted - or even mde aor accdes?
I think you'll have to replace custom menus with custom ribbons at the very least if it is a runtime.

Kelvin

Author

Commented:
Thanks for all your help!
je

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial