Results 1 to 5 of 5
  1. #1
    JamesAccess1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    4

    Combing a DSN file and accde


    Hi,

    I have a access front-end and an sql server back-end.
    I created this form and created a dsn file as a connection between the two, this file uses SQL authentication and set up the the user login details and permissions on the sql back-end, also saving the password when linking the tables.
    Everything works fine in the form while I am on the server where I have created the form originally.
    although when I moved the accde and dsn file to another server, the user logging in gets an error that Login failed for user <Domain><JohnDoe>.
    Is there any way of combining a DSN and accde so this error doesnt occur and the user can log in freely?

    James

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    The DSN (file/user/system) is no longer needed or used after you link the tables, the connection information is stored inside Access (look in the msysObjects system table in the Connect field. So you need to check for other causes of the failure, usually the absence of the same SQL driver used to establish the initial connection. Check your firewall settings on both servers as well.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    JamesAccess1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    4
    Quote Originally Posted by Gicu View Post
    The DSN (file/user/system) is no longer needed or used after you link the tables, the connection information is stored inside Access (look in the msysObjects system table in the Connect field. So you need to check for other causes of the failure, usually the absence of the same SQL driver used to establish the initial connection. Check your firewall settings on both servers as well.

    Cheers,
    Thanks for the reply, The drive is mapped on the server which holds the accde and dsn file. The user then is running this on his local PC. The Database is on a server of its own.
    Would the SQL driver not be common accross as they are connecting to the DB server?
    Sorry, Im new to access I'm just trying to get my head around the problem.
    Would the windows cred be cached by any chance therefore defaulting to using them?
    The firewall settings match in both servers as well.

  4. #4
    JamesAccess1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    4
    Working now,you were right about the firewall settings. Thanks

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Glad to hear!

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

Similar Threads

  1. Replies: 8
    Last Post: 12-17-2020, 08:55 PM
  2. ACCDE file does not work :(
    By NJMike64 in forum Access
    Replies: 2
    Last Post: 03-09-2016, 12:08 PM
  3. ACCDE file read only????
    By Jen0dorf in forum Access
    Replies: 10
    Last Post: 11-29-2015, 03:16 PM
  4. .ACCDE File Format
    By kpo in forum Access
    Replies: 3
    Last Post: 10-23-2012, 11:00 AM
  5. Cannot create ACCDE file
    By swilliams in forum Access
    Replies: 1
    Last Post: 06-03-2010, 03:41 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