Results 1 to 2 of 2
  1. 07-06-2010, 12:33 PM #1
    aspfun
    aspfun is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    10

    How to code to link all SQL server tables via odbc?


    There are about 500 tables in SQL server.
    How to code to link all SQL server tables via odbc?
    Reply With Quote Reply With Quote
  2. 07-17-2010, 08:29 PM #2
    HiTechCoach's Avatar
    HiTechCoach
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    This might help:

    Relink ODBC tables from code

    Boyd Trimmell aka HiTechCoach
    Microsoft Access MVP
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. link sql server table to access
    By broken_ice in forum Access
    Replies: 0
    Last Post: 06-28-2010, 12:50 PM
  2. Import or link fields via ODBC
    By smoked1 in forum Import/Export Data
    Replies: 9
    Last Post: 10-30-2009, 03:55 AM
  3. how to automate odbc connect creation to connect access to sql server
    By marianne in forum Access
    Replies: 5
    Last Post: 03-29-2009, 07:20 AM
  4. How To Connect to SQL Server Database using VBA code in Access
    By wtolentino in forum Access
    Replies: 0
    Last Post: 03-09-2009, 12:20 PM
  5. Unable to import or link tables through odbc in Access SP2
    By Dave Jenkins in forum Import/Export Data
    Replies: 3
    Last Post: 11-09-2005, 11:51 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums