Results 1 to 2 of 2
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011

    PASSING PERMISSIONS into ODBC SQL SERVER Connection with Query

    Hello, I have a query that looks into a SQL Server table and deletes rows with certain criteria and inserts rows with certain criteria in access 2010. My problem is, as an Admin i have the permissions to delete and insert into the SQL server table. For my users to run these queries, they would need the same permissions as me. I dont want to do this due to security issues (i work for a big organization)

    My question is: is there a way to pass the credentials (server name, authentication, password, etc) into the sql server as part of the query? will this even work or is the only way to grant the users permissions. let me know if anyone has other suggestions. thanks..

  2. #2
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    unless someone knows sql server 2005 very well, that would be nice too, one way or another i just need to automate this process, i just know more access than sql server. the process is this (this is how its set up in access):

    1)look into dbo.list table in sql server, delete anything that has a value of "gap" in the "detail" column.
    2)grab ID's from a linked table to a excel spreadsheet
    3)insert these IDs into the same table as step 1 and insert the value "gap" into the "detail" column.

    thats it, pretty simple..

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

Similar Threads

  1. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  2. Replies: 5
    Last Post: 10-25-2011, 08:01 AM
  3. ODBC connection and splitting the DB
    By crowegreg in forum Access
    Replies: 3
    Last Post: 08-30-2011, 11:02 AM
  4. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Reports
    Replies: 0
    Last Post: 03-30-2011, 10:06 AM
  5. ODBC connection
    By avicenna in forum Import/Export Data
    Replies: 2
    Last Post: 08-02-2010, 02:33 AM

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 - Senior Forums