Results 1 to 3 of 3
  1. #1
    Yash20 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    2

    Creating DNS in Users Access Database which has linked tables connected to SQL

    Hello All,

    I have Access Database in shared location but when I run the query it populates following error "ODBC--connection to 'C58DG001SQL' failed."

    But when I run it by logging in to the remote desktop connection where the actual database is located, it runs fine. I am trying to automate this process, instead of logging everytime using remote desktop connection. I have placed this Access Database in a shared location and created a BAT file which is scheduled using Task scheduler and will run the Access Query. But unfortunately I encountering SQL connection error.

    Can anyone provide me a solution for this.

    Regards,


    Yash20

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Use the odbc and link the tables you need, also click SAVE PASSWORD during this connect, then the tables can be used in queries.
    Zero Code needed.
    It Always works.
    No BAT file.

  3. #3
    Yash20 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    2
    Thank you for the response!!

    I have certain challenges in obtaining the desired results.

    1. I use separate User Name and Password when logging into the Remote Desktop hence when I run the Access query it works.
    2. When I Login using the Mapped network and run the Access query it throws error saying "ODBC--connection to 'C58DG001SQL' failed." May be because that is my credentials.

    So my question is when I create ODBC connection from my system, do I need to use the Remote desktop credentials and not mine, since I do not have access to that SQL server.
    How can I check the SQL server name to be provided as I have no idea which SQL server they have connected.

    Regards,
    Yash20

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

Similar Threads

  1. Multiple users querying linked tables
    By vadnagra in forum Import/Export Data
    Replies: 6
    Last Post: 09-21-2016, 01:31 PM
  2. problem at creating a query that linked to 2 tables :(
    By lonlyspartakos in forum Access
    Replies: 2
    Last Post: 12-14-2015, 07:46 AM
  3. Replies: 2
    Last Post: 11-23-2015, 06:40 PM
  4. Replies: 4
    Last Post: 02-11-2014, 02:40 PM
  5. Replies: 3
    Last Post: 06-29-2012, 08:58 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