SharePoint Survey
A SharePoint survey list enables you to create multiple choice, fill-in fields or rating questions that you want other team members to answer. The answers are of course given in the same list, and the survey list also helps you summarize the results.
SharePoint list limit
Surveys can be very useful, and often you want to store the results so that it is possible to review them later. However, the SharePoint list view limit of 5000 rows will eventually give you problems if you keep the data in SharePoint. The best option is to archive the surveys in a database.
Survey archive problem solved
Most lists can be archived to an Access database directly from SharePoint, but you cannot do that with surveys. SP Archive solves that issue, as the kalmstrom.com Solution can archive SharePoint surveys in the same way as all other lists.
Database choice
SP Archive gives a choice of Access and SQL Server database, which is an advantage even for lists where export to Access is possible. For big organizations with much data, the more powerful SQL Server database is a better option than Access.
Column choice
Another benefit of SP Archive is the selection possibilities. This means that you can decide what parts of the list you want to archive. Maybe you don't need to keep all columns in the survey?
Subscribe
Try SP Archive
CEO and Systems Designer
kalmstrom.com Business Solutions
No comments:
Post a Comment