Results 1 to 3 of 3
  1. #1
    BobGHW is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    May 2013
    Posts
    2

    How to link access 97 frontend to sqlserver backend

    Hi, I have migrated an access 97 backend to sql server 2005 database now need to link tables in access97


    to the sql server backend. The access 97 database is on a network drive.

    How can I create a dsn for the access db that's on a network drive?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,900
    I usually use ODBC. Here is a good write-up on how to do that: http://fontstuff.com/ebooks/free/fsL...oSQLServer.pdf
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    BobGHW is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    May 2013
    Posts
    2
    Quote Originally Posted by JoeM View Post
    I usually use ODBC. Here is a good write-up on how to do that: http://fontstuff.com/ebooks/free/fsL...oSQLServer.pdf
    Thanks, that was what I was looking for.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-16-2013, 12:35 PM
  2. Access Switching to frontend and backend
    By caliskier in forum Access
    Replies: 4
    Last Post: 11-19-2012, 11:58 AM
  3. Replies: 1
    Last Post: 03-01-2012, 09:06 AM
  4. Passwording frontend / backend Access 2010
    By erkwong in forum Security
    Replies: 0
    Last Post: 01-30-2012, 01:28 PM
  5. Replies: 1
    Last Post: 11-25-2011, 11:16 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 - Senior Forums