Windows Whats wrong with MS access?

I keep hearing people say that MS Access is s**t. So i was just wondering why?
I dont know how to use any other databases but from what i've seen access doesn't seem too different to me. So what is it that sets all the others apart from access?

 

nothing, those that rubbish it are either in the "all things MS suck" or ones that deal with SQL servers like oracle etc, which are far more powerfull, however, as of office 2007, access runs on the same database engine as Sequal server 2007 so its basicaly the same.

 

The only database experience I have is with Access and SQL Server, so these difference only apply to these two platforms.

Access has a 2GB file size limit. Might seem a lot, but we regularly hit this limit at work.

Access processes queries record by record. This means that when you ask it to give you results from a table using specific criteria, Access looks at each record and says, "Is this it?" This can take quite a while. SQL Server does a better job of indexing the records and selecting them in the appropriate groups.

Access has user-level access controls, but they are intentionally limited, difficult and clunky. The idea is that you'll want to upgrade to SQL Server, which has these features built-in and are much easier to use.

However, remember that no database platform is without its limitations. If Access is working for you, go ahead and use it. SQL Server has it shortcomings as well, not the least of which is the pricing structure. But it's much better and reliable than Access.

 

Ah. Then let me add the caveat that at work we use SQL Server 2000 and Access XP / 2003.

 

touché