Results 1 to 5 of 5
  1. #1
    danieltaylor is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    12

    Link access front end from client computer to SQL back end in server computer

    Hello everyone...
    Im a newbie in SQL... Ive already created an access database (2010) and successfully up-size to SQL using Upsizewizard.... When i test the access_fe from the server computer everything works fine any changes i made in access are reflected to SQL_be and vice versa.... Now the problem is im planning to distribute the access_fe to my colleagues/office mates but how can i relink/connect my access_fe (from a client computer) to the SQL_be (resides in the Server Computer).... Ive struggling with this one for about a couple of days.... Hope someone can show me how to do this step-by-step... from SQL to Client configuration.



    Note: our office uses workgroup/peer to peer file sharing

    Tnx in advance....

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This thread describes how I manage split db. It has sample code for relinking tables but I guess you will have to manually set up ODBC Data Source on each user machine with Windows Control Panel Administrative Tools. If this can be done programmatically, I can't find example.
    http://forums.aspfree.com/microsoft-...ue-323364.html

    Couple of interesting comments in http://forum.winhost.com/showthread.php?t=3127

    However, apparently ADP support is dropped with Access 2013.

    Sorry, know nothing about workgroup/peer to peer file sharing.
    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
    danieltaylor is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    12
    tnx for the reply but i think its not what im looking for when i try to create adp it simply doesnt work

  4. #4
    danieltaylor is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    12
    Finally i managed to relink my access_fe from a client computers to SQL server... But the problem is everytime i closed the access_fe and i open it back i need to relink the tables again to SQL server... Is there any way to automate the process of linking it to the SQL server??? Or maybe a form to pop-up that will ask for log-in Id and password and link the table automatically to SQL server??

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Google: Access relink SQL tables on open

    Does this help: http://access.mvps.org/access/tables/tbl0009.htm

    Put code in a form Open event, set form to open on default when db opens OR call function from an AutoExec macro.

    I never used SQL. No idea why fe loses table links. My split db is Access front and back ends. Table links never an issue.
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 09-18-2012, 08:49 AM
  2. Replies: 2
    Last Post: 08-28-2012, 02:11 AM
  3. Close window error on certain client computer
    By DavidLP in forum SharePoint
    Replies: 0
    Last Post: 05-23-2012, 11:53 AM
  4. Replies: 1
    Last Post: 01-04-2012, 01:39 PM
  5. Replies: 0
    Last Post: 06-14-2009, 09:33 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