<div>
Worked perfect!!! &nbsp;Thanks so much!!!
</div>


<div>
<div class="content wysiwyg-content">
I am running Server 2008. &nbsp;On this server I have two MS Access databases. &nbsp;On these data bases are several macros that connect to a SQL Server database on another server. &nbsp;My problem is that I have to give the db users domain admin rights to get the macros to run correctly. &nbsp;For security reasons I do not want them to have domain admin rights. &nbsp;Is there another type of user on Server 2008 which would allow the ODBC connectivity to take place without allowing to much user rights?
</div>
</div>


I am running Server 2008.  On this server I have two MS Access databases.  On these data bases are several macros that connect to a SQL Server database on another server.  My problem is that I have to give the db users domain admin rights to get the macros to run correctly.  For security reasons I do not want them to have domain admin rights.  Is there another type of user on Server 2008 which would allow the ODBC connectivity to take place without allowing to much user rights?

ODBC Connectivity

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.