Access vs MS SQL

In 9.5 years of experience in Microsoft Dot net, one of the weird difficulty faced by me is using MS Access for the core database application after using Microsoft SQL Server for 9 years. Firebird, SQLite and My SQL didn't give any headaches since I didn't use it beyond ADO.net.

Here are few of the things which I don't like it in MS Access.

• It do not support Entity framework and Linq to SQL. That is why we need to write query. People are trying to write interfaces to support Entity framework, but I didn't find a single simple solutions.
• Whenever you use Multiple joins you should use brackets.
• Adding relationship is quite a mess. There is one to one, one to many. To make it one to many it made me to go back and check the table properties.
• Look at the Edit Relationships dialogue.  Relationship type is One-many.  Some times it will be one – one  and you are trying to change it to one-many but it will not allow. 
• Access database maximum size is 2GB. MS SQL 2016 can take up to 524 PB. [1 Perabyte (PB) = 1024 Terabyte (TB)]
• Access has a maximum of a little over 32,000 objects per database. SQL databases can have over 2 billion objects.  MS SQL is more suitable where scalability is one of the concern.
• Concurrent users—Access has a limit of 255 simultaneous users. MS SQL databases can have over 32767 users at one time.