Results 1 to 4 of 4
  1. #1
    Jetsoon is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    2

    Building a local Access DB vs. Web Hosting (via Sharepoint)


    Hi Everyone,
    I'm a Newbie here and apologize in advance if this question has been asked before...

    I am looking to build a basic Access DB (2010 version) for our company with a basic client table with related order, invoice, and revenue tables. My goal is to offer front facing data entry forms for other users (5 max) at our office where they can add/edit clients, orders etc. and hopefully run/export reports. My question specifically is what options do I have in to Access facilitate these front facing forms w/o requiring users to install and run Access as well (besides myself, the one building the DB)? I'm trying to make this as easy as possibile for the users and am hoping to have the forms web-based.

    I was considering the Web-Based Access DB option and host it with MS Sharepoint/Access Services but am concerned with the limited options you get when you choose to build a web-based DB (versus the traditional DB option). If I build a traditional DB and host the DB file on our local server (my preferred option), can other users access just the data entry forms, reports I create w/o having to install Access on their computers? Do I need to host the forms somehow?

    My apologizes again for the newbie question. Thanks for any help!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Explore Access Runtime http://www.microsoft.com/en-us/downl....aspx?id=10910 Might have to create a user profile on Microsoft Windows Live to open that webpage. It demanded I login.
    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
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    You can have few more options
    1: You can host Back end at your server and connect it to your user front ends ( may be 5- 10 users).
    Option a: Both front end and back end are at server side and load the both on client system through Domain or Terminal services share folders.
    Option b: back end are at server side and front end is at client side load the back end on client system through Domain or Terminal services or through share folders.
    2: Use Back end on SQL server and front end on Access front end is at client side Use LAN to connect them
    3:Use Back end on Share Point and front end on Access front end is at client side Use LAN to connect them
    That way you can use conventional DB of access having many feature which are absent on web based access.
    4: Place a common back end and many front end on cloud ( eg Dropbox drive ) Connect user through internet. thay will update drive data and many user can work at same time. Place a copy on your server Inernal LAN user can work without cloud.
    You can decide the best option as per need.

  4. #4
    Jetsoon is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    2
    Thanks for the ideas here. I will start experimenting with these different options once I get the database further built.

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

Similar Threads

  1. Replies: 3
    Last Post: 06-18-2012, 02:04 PM
  2. MS Access 2010 back-end hosting
    By Born2Gamble in forum Database Design
    Replies: 6
    Last Post: 11-29-2011, 07:46 AM
  3. Building Calendar in SharePoint (Gant View)
    By Alaska1 in forum SharePoint
    Replies: 0
    Last Post: 11-10-2011, 04:37 PM
  4. Access Web Database & Go daddy web hosting
    By choffler in forum Access
    Replies: 2
    Last Post: 10-27-2011, 11:38 PM
  5. Replies: 0
    Last Post: 05-14-2010, 08:43 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