MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Moving Access Reports to Sharepoint 2007

  Asked By: Jennifer    Date: May 08    Category: MOSS    Views: 1467

We are tasked to migrate an access application with dashboard for reports to
The users want to be able to enter/edit /update the data and generate a couple
of reports.

I am trying to get the best approach for this.

These are my thoughts and would like to hear from you any better approach.

1. Store the data in a Sharepoint list as the data growth only about 10% max in
a year and there are about only 150 rows with about 10 coumns right now, mostly
test fields.

2. create a custom asp.net form to enter and update the data in Sharepoint list.
ANd write custom code to update teh Sharepoint list.

3. Not very sure about the reports. if a Dashboard, SQl reporting services
would be better.

I would like to hear your opinion on 1 nd 2 . And especially which approach has
worked for you for the reporying and any issues you had with it.



1 Answer Found

Answer #1    Answered By: Mariel Ferrell     Answered On: May 08

1. Access can actually link to a sharepoint  list, so it would be pretty easy
to bring the data over that way. Putting the data there would be a very
good idea.

2. SharePoint provides data entry forms when you create your list. You can
customize the look of the forms or create your own, but there's no need for
custom code to insert/update; SharePoint does all that out of the box.

3. SSRS does give you a lot of reporting flexibility. Of course we'd need
to know more about the reports  before offering any real opinions.

Didn't find what you were looking for? Find more on Moving Access Reports to Sharepoint 2007 Or get search suggestion and latest updates.