Results 1 to 6 of 6
  1. #1
    Tim@Syosset is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Posts
    4

    Linked Table ODBC connection

    I have an Access Database 2010 .accdb linked to SQL Server 2008.
    Both on the same computer/Server.
    On 7 local computers I have a Shortcut to that Access 2010 Database on the server.
    Everything works fine.



    My problem is I can't figure out how I set up the ODBC connection originally to make it work.
    How do I look at the Access Database and see what odbc connection is being used
    so I can recreate it for another project.

    Tim

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    7 shortcuts to the same frontend file? This is not advised. A multi-user (simultaneous users) db should have a copy of the frontend distributed to each user - they run their own copy.

    Did you set up ODBC with Windows Administrative Tools Data Sources (ODBC) manager?

    What do you see when you hover cursor over table link?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Tim@Syosset is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Posts
    4
    Not that it's the right way, but I started doing it that way 10 years ago and it's been fine. {Shortcuts to Access on Server}
    So for now (Until I do it the right way) how can I go back and figure out how I set it up?
    Do not know what you mean by "Table link" where to hover

  4. #4
    Tim@Syosset is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Posts
    4
    Each of the 7 local computers have Office 365 Access 2013 on them.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    In the Navigation pane of the frontend where tables are listed. Linked tables have a little arrow on left side of table icon. Hover mouse cursor over table icon.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Tim@Syosset is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Posts
    4
    June7 BINGO, I hovered over the linked tables in Objects section. It displayed the odbc link. Thank You
    Did not know that before.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  2. Replies: 8
    Last Post: 09-27-2012, 08:23 AM
  3. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  4. Replies: 5
    Last Post: 10-25-2011, 08:01 AM
  5. Linked tables and ODBC connection strings
    By cwcadm in forum Import/Export Data
    Replies: 7
    Last Post: 05-26-2009, 07:30 PM

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