Results 1 to 4 of 4

ODBC Connection Problem

  1. #1
    Robert2150 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    95

    ODBC Connection Problem

    I have an Access database on an SQL Server.

    It was working fine until I added some ODBC logins to the server. Now when trying to open the DB I get the Microsoft Access Error "ODBC--connection to 'DIOCESEFACDB' FAILED." DIOCESEFACDB is the name of the database back end. Any suggestions. It is a Microsoft SQL Server -2016.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,603
    did you try remaking the ODBC connection via: control panel , ODBC

  3. #3
    Gicu's Avatar
    Gicu is offline Expert
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    849
    So I assume you are using SQL authentication with users having their own logins in the server. What permissions have you granted to those new ODBC logins? As a min they should have dataread and datawrite.

  4. #4
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    631

    Create login on SQL server

    Step 1: create login for server, example = SQL login
    Click image for larger version. 

Name:	CreateSQL_login.JPG 
Views:	16 
Size:	89.6 KB 
ID:	37263


    Step 2: create user for the new login in the database
    Click image for larger version. 

Name:	CreateSNewUser.JPG 
Views:	16 
Size:	84.2 KB 
ID:	37264


    Step 3: set user roles
    Click image for larger version. 

Name:	CreateSetUserRoles.JPG 
Views:	15 
Size:	48.5 KB 
ID:	37265

    step 4: check the new user : log in with new user in the SQL Server mangement studio
    Step 5: create an ODBC connection in Access and test it
    Last edited by NoellaG; 02-04-2019 at 08:20 AM. Reason: typo

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

Similar Threads

  1. ODBC Connection Help
    By mindbender in forum Programming
    Replies: 1
    Last Post: 09-19-2018, 01:11 PM
  2. Replies: 1
    Last Post: 06-25-2018, 04:15 PM
  3. Replies: 3
    Last Post: 04-25-2018, 10:32 AM
  4. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  5. Replies: 5
    Last Post: 10-25-2011, 08:01 AM

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
  •  
Tech Forums: Microsoft Office Forums