Results 1 to 5 of 5
  1. #1
    workinstiff is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    6

    Using Access as Front End for SQL Server

    I am a computer novice with no experience in PHP or SQL Servers in general. Is there anyway to set up Access as a front-end to an MS SQL Server without having coding knowledge? Is there any good wizard that will export data/formats to a SQL Server while still keeping the interface mechanisms of Access? Thanks for any help you can give.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Is there anyway to set up Access as a front-end to an MS SQL Server without having coding knowledge?
    Sure. If you create an ODBC Connection to the SQL Database, you can use it to link the SQL tables to your Access database.

  3. #3
    workinstiff is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    6
    ah good good. Do you know any good tutorials for setting up an ODBC Connection?

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    A Google Search brought back this one, which looks pretty good: http://www.ehow.com/how_4642566_setu...onnection.html

  5. #5
    workinstiff is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    6
    great! thanks so much Joe.

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

Similar Threads

  1. After front end shut down - server shows still open!
    By skyview chick in forum Access
    Replies: 10
    Last Post: 07-10-2012, 04:14 PM
  2. Database Front Ends on a Cloud Server
    By rts in forum Database Design
    Replies: 0
    Last Post: 04-04-2012, 07:17 PM
  3. Access front end for parsing xml string
    By raghu_nandan1 in forum Programming
    Replies: 0
    Last Post: 04-21-2011, 07:58 PM
  4. Replies: 3
    Last Post: 01-15-2011, 11:38 AM
  5. Converting or using Access as a front end for Excel
    By jacko311 in forum Database Design
    Replies: 4
    Last Post: 11-07-2009, 12:19 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