Access.adp (2010) and SQL Server 2014

0 votes

1 answer

391 views

sql-server performance permissions ms-access-2010

                          We are using Access .adp (Access 2010) frontend in combination with SQL Server 2014 backend. At the moment we have a big performance problem with the SQL function permissions(). We have ca. 400 Users on our application. The logon takes 50+ Seconds for an normal user. Sysadmins logon takes 3 seconds. Do you have a solution for this problem?

                        

Asked by M. Kofler (1 rep)

May 4, 2017, 12:58 PM
Last activity: Jun 6, 2021, 07:02 AM

Access.adp (2010) and SQL Server 2014

Related Questions