Everyone seems to be telling you to stick with Access, but when has an Access upgrade ever gone smoothly? I would suggest you use an eval copy of Access 2010 to test upgrading to see what breaks before making any decisions. If it looks like it will mostly be a smooth upgrade than stick with Access. But if it breaks a ton of things then that helps make the case for migrating to Open Source offerings.