Access 2003 upgrade to Access 2007

[access2010]

We would like to upgrade our software from Access 2003 to Access 2007.

Do we have to do anything special or just upgrade our databases?

Thank you.

Nicole

 

[sonic8]

An A2003 to A2007 migration should be mostly straight forward.
However, it is impossible to say that for sure without knowing your project in detail.
On thing potentially needing attention would be custom menu and tool bars. These were replaced by the Office Ribbon in A2007 and classic menus were moved to a subsection of the ribbon.
There are a couple of more exotic areas also potentially causing problems, but I doubt anyone will remember in detail. - After all, you are upgrading from a 20 year old version to a 17 year old version. One could ask why you even bother with this. Both version are out of support for a long time.

 

[CJ_London]

only other potential issue I can think of is if the 2003 .mdb uses a .mdw file for security. That was deprecated in 2007 so cannot be modified although still supported for security through to 2010 and later. So you need to keep that file although personally I would remove that security option before upgrading and write your own alternative.

 

[gemma-the-husky]

I think we would all agree that A2007 has been improved by later versions. A2010 is better, but if I was upgrading, I would go to the latest version you can get.

I would keep A2003 on your computer even so, as long as it works
Additionally, I much prefer the A2003 switchboard to the later versions I have seen.
Also I prefer A2003 menus to modern ribbons.

 

[Cotswold]

I have converted Access97 & Access2000 to Access2010 and later without any major issues.
I tend to think later versions are always better. After all you would want your clients to be using the latest version of your software. I certainly did.