There are some bugs & issues to be resolved in A2007: http://www.alis.cz/relax/download/beta/Access2007_bugs.rar ~27MB pwd=A2007bugs
The best way is to try A2007. You could run former MDB (MDE) format apps in A2007 (not sure about A97). WARNING: You may experience incompatibility issues ie...