Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I know that this could be a wide-open question, but I hope that I can get some constructive feedback about a project I'm working with.

    We have a relational database developed in Access. It's not terribly complicated, but it does involve around a dozen tables. As is often the case, there are those who want to see if it can be ported to SharePoint and use views instead of reports.

    Aside from the huge amount of difficulty I have had porting even simple, flat Access apps to SharePoint, I wonder what compromises can be reached. For example, can it remain an Access database and yet have some of the reports accessible in real time via SharePoint? (One of the biggest advantages, ostensible, would be SharePoints security, which seems as easy as Access; seems arcane.)

    What management (those who just want it done!) would like to see is a list of reports in their SharePoint collaboration site, which they can just click on and view and print. The more technical minded want to see if it could leverage security so that only those with the correct permissions could get in and enter/edit data.

    Would any of you have some time to give me some (experienced) feedback about what is possible, what MIGHT be possible, and what would be just way too hard. We don't want a huge development effort for this, and I haven't found any "real world" information that seems to address the difficulties we've been facing (such as turning Reports into views, maintaining relationships between SharePoint lists.)

    Your two cents?
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  2. #2
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    We are just starting to move some custom Access/Excel applications to SharePoint.

    At the moment, our idea is to convert the Access tables to SharePoint lists, and let the users filter the lists however they want. A select group of people may still use Access to make changes to the SharePoint data via linking. We haven't decided (yet) on how we will deal with actual Access reports, or if we'll even keep them.

    I picked up Office and SharePoint 2010 Userís Guide: Integrating SharePoint with Excel, Outlook, Access and Word from Amazon. It may give you some guidance.

    Amazon also has a 2007 version if you are using SharePoint 2007.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •