I’m not talking about being able to get something that you want – to me MS Access is just the opposite. I may be biased towards real databases, but Access seems to make things more difficult to me. I think there was a day (maybe 10 years ago) where Access was a useful product for small businesses who didn’t have the time, money or experience to set up a real database server. Today however, the tides have shifted and setting up MySQL, or even SQL server is not that difficult. There are front ends for both which make creating and adding entries to the database easy.
More importantly though, I think people have a tendency to start a little pseudo-db in Access for their own personal use, then someone else says “Hey, can I use that?” and they get a link to it. One thing leads to another, and before long it’s like rabbits – everywhere you look, everyone is using the SAME Access pseudo-db to look things up. There is no transactional support, race conditions can come up, and data can get corrupted in a heartbeat. All-in-all, it’s a very bad thing.
So, even if it’s something simple that you think is just going to be used once, and only by you – rethink it. And don’t let the excuse “I know Access” convince you that it’s the best or even quickest solution. MySQL + phpMyAdmin is a rock-solid combination that will let you do most of what Access does (no, you can’t do form design in phpMyAdmin, but who would want to), will be faster getting the data, and can be expanded to support thousands of users making thousands of queries. Not to mention you might actually learn something about using a database in the process!
Remember the phrase: Access is the spawn of Satan….