First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and I must say I had a good time with Database at that time. As time passed by, I moved from MS Access to SQL Server. Well, as for my friend’s email, his reasons considering MS Access usage really made me laugh. MS Access may have a few points where it totally makes sense to use it. However, in the email that I received, there was not a single reason which was valid. In fact, I thought it is an April 1st joke- just delivered a little earlier. Let us see some of the reasons from that email. Thanks to Mahesh Bhesania for sending this email to me.
- MS Access comes with lots of free stuff, e.g. MS Excel
- MS Access is the most preferred desktop database system
- MS Access can import data from MS Excel and SQL Server
- MS Access provides a real time database
- MS Access has a free IDE-to-VB Script
- MS Access fits well in your hard drive
I actually think that the above points are either incorrect beliefs of some users, or someone just wrote them to give some laughter with such inaccurate data. And, for the same reason I decided to browse the Internet and do some research on MS Access database to verify my thoughts.
While searching on this subject, I found the following two interesting statements from the site: Microsoft Access Database, Why Choose It?
- Other software manufacturers are more likely to provide interfaces to MS Access than any other desktop database system
- Microsoft Access consulting rates are typically lower for Access consultants compared to Oracle or SQL Server consultants
The second one is may be the worst reason for you to switch to MS Access if you are already an SQL Server consultant.
With this cartoon, have you ever felt like you were one of these chickens at some point in time? I guess that the moment might have just happened before the minute we say “I guess we were on the same page?” Does this mean we are IN the same table, or ON the same table?! (I accept bad joke!)
It is All Fools’ Day after all, so just laugh! If you have something funny but non-offensive to share, just leave your comment here.
Reference: Pinal Dave (https://blog.sqlauthority.com), Cartoon source unknown.