Results 1 to 2 of 2
  1. #1
    lrz is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018

    Linking access to sql server express

    I need to link server to sql tables from access 2016. I've created an access table containing all table names to link. Sql server has a password. I need something to read from that table and automatically link. Any idea? Thanks for your help

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Somerset, UK
    I'm unclear whether you want to link tables already in SQL Server to an Access FE or export your Access tables to SQL Server

    For the first of these, you either need to setup an ODBC connection or use a DSN-less connection string.
    The first is easier but needs to be done on each workstation running the FE.
    The second method is more challenging for a new user but only needs to be done once.

    There are plenty of good tutorials online for each method. Do a forum search or Google search.

    For the latter (export to SQL), use the tools built into SSMS to import the tables from Access
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    sking for help isn't giving up. Its refusing to give up.

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

Similar Threads

  1. Replies: 8
    Last Post: 11-05-2015, 06:06 AM
  2. Replies: 3
    Last Post: 07-16-2014, 10:44 AM
  3. Replies: 1
    Last Post: 04-21-2011, 07:12 PM
  4. odbc vista SQL Server 2008 Express Slow
    By BrianM in forum Access
    Replies: 2
    Last Post: 02-07-2011, 11:47 AM
  5. Convert Access 07 ADO code to SQL Server Express 2008
    By jrdnoland in forum Programming
    Replies: 8
    Last Post: 04-14-2010, 05:57 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