Results 1 to 5 of 5

SharePoint and Access 2010

  1. #1
    ksmith is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    59

    SharePoint and Access 2010

    I was given the task of writing a project management database. This database will be used in two separate facilities separated by about 75 miles. The database will be used to keep track of upcoming projects. Management in both places need real-time up to-date project status information.
    How is the best way to do this? I have Access 2010 and have been looking at the SharePoint stuff. This will be a runtime application. Does one copy of SharePoint cover everyone? What about security? This will be future products for my company so this information has got to be secure. I was wondering if anyone has had a chance to build any applications with this and could share some ideas.
    One of the ideas that was kicked around was keeping everything up to-date via e-mail. Any ideas on using e-mail or using Microsoft SharePoint would be gratefully appreciated.
    Thanks in Advance,


    K. Smith

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    Sharepoint is a large Microsoft product unto itself. As its name implies, it serves the role of sharing documents/files/data and that includes Microsoft Access tables.

    A geographically distributed, and potentially browser enabled, database involves a variety of parameters involving networking, costs, security, and user experience which must be balanced.

    If, as you mention, 'real time up to date' is the requirement then you should look at a web enabled solution in which case Access/Sharepoint is one approach. In your local area are probably web developers that will offer a solution and which may use totally different technology - and for which may not matter strongly because you will focus on the features & user experience primarily rather than the development environment.

    Besides using a web developer or purchasing and running Sharepoint inhouse one can also consider: Intuit offers an online database Quickbase. www AccessHosting com offers sharepoint hosting. www eqldata com offers browser enabling an Access applicaton.

  3. #3
    ksmith is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    59
    Thanks for the reply.

    I'm not sure which way we are going to go with this. Is updating data via e-mail a viable or even a do-able option?

    And do you know if each PC that will use SharePoint (if we go that route) will have to have their on copy of SharePoint?

    Again Thanks,

    K Smith

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    There is a data entry via email method in Access2007.
    Sharepoint is a big product. It runs on a server, and not on anyone's individual PC as does Access.

    Both topics require that you get an Access2007 textbook and read these topics in depth. Sharepoint has its own books and its own certifications in addition.

  5. #5
    ksmith is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    59
    Thanks NTC for the help.

    KSmith

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

Similar Threads

  1. Access 2010
    By Desstro in forum Access
    Replies: 8
    Last Post: 01-19-2016, 04:09 PM
  2. Convert access 2003 to access 2010
    By Vera in forum Access
    Replies: 3
    Last Post: 07-16-2010, 11:01 AM
  3. 2007 Access DB won't work in 2010 - 64 bit
    By InvGrp in forum Access
    Replies: 2
    Last Post: 07-12-2010, 08:45 AM
  4. MS Access 2007 vs 2010
    By ralphjramirez in forum Access
    Replies: 2
    Last Post: 05-06-2010, 06:30 PM
  5. Replies: 1
    Last Post: 09-26-2009, 02:55 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
  •  
Tech Forums: Microsoft Office Forums