• 1. User must have connection rights (login) to the SQL Server or be member of an A.D. group that has connection rights to the SQL Server.

    2. User must have the necessary access rights to the concerned database or be member of an A.D. group that has access rights to the concerned database.

    3. As the Access database is a Front-End (i.e. it does not contain the data tables), it should be copied on each client machine (never share a F.E.).

    4. If a connection string is used (i.e. no attached tables or dynamic attached tables), include "Trusted_Connection=Yes" in the connection string (e.g.: "ODBC;DRIVER={SQL Server};SERVER=Iskender;DATABASE=PictureManagerSQL;TRUSTED_CONNECTION;Yes;").

    5. If the F.E. uses attached tables through a DNS (ODBC defined connection), use an account that fullfill 1 and 2 here above when defining this ODBC connection (it can be a system-defined DNS connection or a user-defined DNS connection).

    Have a nice day!