• It depends on the connection settings. How is the Access front end set to connect with SQL Server? Via SQL Server or Windows authentication.

    K. Brian Kelley
    @kbriankelley