Home Forums Microsoft Access Microsoft Access Security in Multiuser environment (Ms Access Project or Ms access database) RE: Security in Multiuser environment (Ms Access Project or Ms access database)

  • August 5, 2010 at 10:55 am

    #1202949

    kiranmai.gompa (7/7/2010)

    hi,

    Iam developing a database with Access as front end and Sql Server 2005 express as back end. It should be used in a multi-user environment. Some users should have access to all details and some don't.

    Which would be the best option in this situation (ms access project or database?)

    I am new to Sql. I want the easiest method of implementing security.

    please help

    Thanks in advance

    The best way is to define and specify your security settings in the SQL Server.

    And then build your front-end MS Access ADP project directly linked to that SQL Server with Windows Authentication.