Hi
This is tied to an earlier post I had, see http://www.access-programmers.co.uk/forums/showthread.php?t=284480
In summary - I'm using Access 2010 ADP with SQL Server 2008 R2.
If a user isn't a member of the Sysadmin server role, Access ADP reports will run slowly for that user. This wasn't an issue when users were on Access 2003.
After days of Google, the only solution I've found online is add users to the Sysadmin Server role. Then their reports speed right up.
I haven't found any other solution.
In addition to this Access_Reports database, there are other several databases on the server. I don't want to give users full rights to those. ( I'd rather not give Sysadmins permission to Access_Reports either, but needs must.)
Is there a way I can just give Sysadmin permissions to only the Access_Reports database?
Or a way to just give this permission when Access launches?
Thanks
This is tied to an earlier post I had, see http://www.access-programmers.co.uk/forums/showthread.php?t=284480
In summary - I'm using Access 2010 ADP with SQL Server 2008 R2.
If a user isn't a member of the Sysadmin server role, Access ADP reports will run slowly for that user. This wasn't an issue when users were on Access 2003.
After days of Google, the only solution I've found online is add users to the Sysadmin Server role. Then their reports speed right up.
I haven't found any other solution.
In addition to this Access_Reports database, there are other several databases on the server. I don't want to give users full rights to those. ( I'd rather not give Sysadmins permission to Access_Reports either, but needs must.)
Is there a way I can just give Sysadmin permissions to only the Access_Reports database?
Or a way to just give this permission when Access launches?
Thanks