I am redesigning our database at work to be more functional and efficient. I will be using Access 2013 and everywhere I have read says that the ULS has been totally removed and you basically have to design your own level of security and even that is easy to get around with a little bit of computer knowledge. We have roughly 10-15 users of the FE db who will be running Access Runtime but many that need specific access to certain areas, so they can't be grouped very easily. Ideally I would like to have a switchboard that groups each area (ex. Purchasing, shipping, job costing) and give users access based on those which will then take them to a "sub-switchboard" with all the reports and forms. I have read that SQL Express is free and capable of user login permissions, but it seems every thread I read about ULS, it is not suggested as an alternative and I don't understand why. Would someone be able to give me a definitive answer on the best way to have a database with user level permissions that are easy to update and modify when need be?
I didn't know if I should post this into the SQL Server forum or Security so if it is more appropriate there it can be moved.
Thanks,
Josh