Results 1 to 2 of 2
  1. #1
    camilo echeverry is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    1

    Unhappy Change Sql database name in access query


    Hi,

    I have a lot of query's in access that grab information out of an sql database. My problems is that the sql database change the name and I need to know what I can do in this case? I do not see where to change the database name in access or change any odbc setting to make any request for the old sql server to go to the new server.

    Rgs

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    If you see the table icon attached with a globe then it is attached via the OCBC manager
    in control panel, admin tools, data service odbc

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

Similar Threads

  1. Replies: 2
    Last Post: 04-29-2014, 05:03 PM
  2. Change Primary Location of Access Database
    By MichaelWR90 in forum Access
    Replies: 8
    Last Post: 06-03-2013, 09:45 AM
  3. Query Format change for Access
    By shabar in forum Queries
    Replies: 7
    Last Post: 02-01-2013, 12:21 AM
  4. Change layout on access 2010 contact database.
    By trumpetman in forum Access
    Replies: 0
    Last Post: 06-18-2012, 05:02 AM
  5. Replies: 0
    Last Post: 03-01-2011, 10:47 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