Results 1 to 2 of 2
  1. #1
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110

    Need help linking frontend access into SQL database

    Hi All

    Need some help, I have a access 2010. Database which I split into frontend and backend which works well.

    I have decided to move the database into SQL, I used the export wizard and moved the database into SQL which seemed to work, and it I look at the backend which SQL made I seem to see my data, and if I open SQL it seems to be in that to.

    But my problem is, how do I link the access frontend to the SQL backend.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I am not sure if this helps, because I don't know your environment, but our SQL data is usually on separate SQL servers, so we create ODBC links to that server, so then we go to link the table, we got to External Data -> More -> ODBC Database, select the ODBC link, and browse to the database and then table name.

    If your front-end and back-end are all on the same server, I am not sure if that is all necessary.

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

Similar Threads

  1. Need help linking my SQL backed to frontend
    By winterh in forum Import/Export Data
    Replies: 3
    Last Post: 06-07-2012, 04:20 AM
  2. Replies: 2
    Last Post: 03-28-2012, 11:35 AM
  3. Replies: 1
    Last Post: 11-25-2011, 11:16 AM
  4. Linking an Access database to a web interface
    By Yesideez in forum Import/Export Data
    Replies: 1
    Last Post: 06-27-2011, 10:17 AM
  5. 2 SQL Database sources one frontend
    By kevinharding in forum Programming
    Replies: 3
    Last Post: 03-22-2006, 06:34 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