I developed an Access database on my laptop, which has Access 2003.
The workstations in our office have Office 2007 installations, which did not include Access (Student and Teacher edition possibly?).
Since we all "grew up" with Office 2003 and earlier, even quick adapters feel a bit like lost puppies, full of "Where did they put THIS function???" in Office 2007. The (cough) terms of endearment for Office 2007 have been... colorful. :-P
I additionally have some concern, as the only DBA to be supporting Access, of myself appearing foolish and fumbling, since I've never touched Office 2007, and fear many of those "Where is..." moments myself. And since I came from larger DBMS environments, I'm a bit new to Access as it is. My intuition is, I don't need the extra chances to create the impression of looking even less knowledgable than I am. Yikes...
I'd like to pick up a [legal] copy of Office 2003, and install just the Access component on the workstations that I'd like to deploy this database on.
I have gone through a test installation on my workstation just to prove out that there wouldn't be any fundamental issues, and the installation completed normally, and without performing any actual testing, Access does open without issue, and appears that it'll function normally.
Can anyone think of any concerns that might exist with doing this?
Can anyone come up with a compelling reason to go the 2007 route that would offset the lack of familiarity and roughly 6x expense justification, to run a DB that was built in Access 2003?
Any other heads up?
Thanks in advance!