Rx_
Nothing In Moderation
- Local time
- Today, 11:00
- Joined
- Oct 22, 2009
- Messages
- 2,803
For those Access develops who enjoy a debate.
http://www.sqlservercentral.com/articles/Editorial/109957/
Access Disdain
By Andy Warren, 2014/07/17
Today we have a guest editorial from Andy Warren as Steve Jones is at SQL Bits.
I learned databases back in the days of DOS and DBF files. If you ever worked with dBase III or anything that used the DBF format you wound up with a folder full of various files. I remember trying out Access v1.1 (May 1993 for those who wondered). It was I think the first Windows database I had used and I remember thinking how nice it was to have all the “files” in a single container, the MDB. I went on to use it a lot. I built a couple apps that used it for a data store, I used it a lot for ad hoc reporting and data entry/fixing, and I worked at a company that used it as their primary ETL solution.
Later I moved on to SQL Server 6.5 and 7.0. I remember learning to create indexes in SQL and being struck that I had to give them names - in Access you just entered the columns, no name required. That was a worthwhile tradeoff just to be through with doing the compact/repair operation that seemed to be required all too often in Access.
(see more at link above)
Access Users might actually enjoy the 97 post about this article:
http://www.sqlservercentral.com/Forums/Topic1593357-263-1.aspx
`
http://www.sqlservercentral.com/articles/Editorial/109957/
Access Disdain
By Andy Warren, 2014/07/17
Today we have a guest editorial from Andy Warren as Steve Jones is at SQL Bits.
I learned databases back in the days of DOS and DBF files. If you ever worked with dBase III or anything that used the DBF format you wound up with a folder full of various files. I remember trying out Access v1.1 (May 1993 for those who wondered). It was I think the first Windows database I had used and I remember thinking how nice it was to have all the “files” in a single container, the MDB. I went on to use it a lot. I built a couple apps that used it for a data store, I used it a lot for ad hoc reporting and data entry/fixing, and I worked at a company that used it as their primary ETL solution.
Later I moved on to SQL Server 6.5 and 7.0. I remember learning to create indexes in SQL and being struck that I had to give them names - in Access you just entered the columns, no name required. That was a worthwhile tradeoff just to be through with doing the compact/repair operation that seemed to be required all too often in Access.
(see more at link above)
Access Users might actually enjoy the 97 post about this article:
http://www.sqlservercentral.com/Forums/Topic1593357-263-1.aspx
`
Last edited: