Results 1 to 3 of 3
  1. #1
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48

    MS Access Front End MS Excel Backend

    Hi! I just want to ask if it's possible if i use MS Excel as my backend? Actually I'll just use MS Access to create a UI for my Excel database. Is it Possible that when I put a Data using MS Access(as front end) it will auto fill my database on Excel?

    Any answer will help. Thank you

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    My experience is that spreadsheets cannot be edited through Access link. They can be filtered, sorted, searched, used in queries and joined to other tables/queries, but not edited.
    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
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Oh I see. Just thinking of that. That I can view or whatever but I can't edit. By the way. Thanks a lot sir June7!

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

Similar Threads

  1. Replies: 1
    Last Post: 11-25-2011, 11:16 AM
  2. Access 2007 Database Backend Security
    By bakkouz in forum Access
    Replies: 2
    Last Post: 10-10-2011, 11:12 AM
  3. access split DB to mySQL (backend only)
    By rnbwkat in forum Access
    Replies: 1
    Last Post: 05-31-2010, 07:19 PM
  4. 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
  5. Access as backend for Web Pages
    By LornaM in forum Programming
    Replies: 10
    Last Post: 05-04-2009, 08:02 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