Results 1 to 3 of 3
  1. #1
    EuniceH is offline Novice
    Windows Vista Access 2000
    Join Date
    Oct 2011
    Posts
    11

    SQL Server function needs permissions

    This SQL Server procedure runs by any windows-validated user from Microsoft Access:
    gdbSQLServer.Execute "[dbo].[udpARAging] '" & CDate([Forms]![frmPickDate]![txtPickDate]) & "'", dbSQLPassThrough

    but this SQL Server scalar-valued function needs permissions, why?
    GenerateInfoCallSSN = gdbSQLServer.OpenRecordset("SELECT dbo.udfTempSSN() As TempSSN", dbOpenSnapshot, dbSQLPassThrough).Fields(0)

    for both:


    Public gdbSQLServer As DAO.Database
    Set gdbSQLServer = DBEngine.Workspaces(0).OpenDatabase _
    ("", False, False, "DRIVER=SQL Server Native Client 10.0;SERVER=USER-HP\GCUSERHP;DataTypeCompatibility=80;DATABASE=GCDA TA;APP=Microsoft Windows Operating System;Trusted_Connection=Yes;MULTIPLEACTIVERESULT S=Yes;Pooling=True")

  2. #2
    hapm is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    197
    How the permissions are set on the server side for both functions?

  3. #3
    EuniceH is offline Novice
    Windows Vista Access 2000
    Join Date
    Oct 2011
    Posts
    11
    Quote Originally Posted by hapm View Post
    How the permissions are set on the server side for both functions?
    The udpARAging procedure has no permissions listed.
    For the udfTempSSN function, I had to add these permissions in order for Microsoft Access users to use it. I'm not sure which one hit the spot, but I granted both.
    --BUILTIN\users - Execute permission
    --public role - execute permission

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-17-2012, 05:51 PM
  2. MDB Permissions
    By esbrega in forum Security
    Replies: 0
    Last Post: 03-08-2012, 03:46 PM
  3. You don't have the necessary permissions
    By registan in forum Access
    Replies: 11
    Last Post: 02-19-2012, 12:53 PM
  4. Permissions
    By helpaccess in forum Access
    Replies: 2
    Last Post: 04-22-2011, 03:33 PM
  5. Date function in Terminal Server
    By eww in forum Access
    Replies: 8
    Last Post: 11-16-2010, 04:24 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums