Originally Posted by ahmed_optom
its fun, but you realise just how powerful and user friendly access is when you start messing around with sql/mysql.
Your perception of power will depend on what you know about SQL server and its Management interface. Anyone who writes SQL in MSSQLSMS would consider Access featureless or worse.
SQL Server supports a far simpler join syntax as well many more joins in queries such as OUTER APPLY, CROSS APPLY and FULL OUTER JOIN to name a few.
Table Valued Functions that return a table that can be used in a join.
SQL can run .NET complied functions. It can read and write to the file system. File tables present themselves as a File System Share. Putting files into the table is as simple as copying the file into a folder.
Full Text Search allows the content of these files to be indexed. The indexes can be queried to find any word combinations occurring near each other in the documents.
SQL server supports connections straight into LDAP databases such as Windows Active Directory. I can directly query anything about my users without resorting to masses of VBA like I had to in Access.