Solved

Windows SharePoint Services 3.0

Posted on 2011-02-24
8
405 Views
Last Modified: 2012-05-11
Does anyone know how to mass delete records in WSS 3.0 ?

For example : we have one tab which contains over 3,000 records if we want to delete record ID from 1 to 2,000. Is there anyway we can do it quickly? (Like in Excel you can highlight row 1 to 2000 and then delete them all with one click)
0
Comment
Question by:City_Of_Industry
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 42

Assisted Solution

by:zephyr_hex
zephyr_hex earned 75 total points
Comment Utility
0
 
LVL 8

Assisted Solution

by:nsyyoung
nsyyoung earned 75 total points
Comment Utility
THere may be a faster way, but you could create a view with ID between 0 and 2001, open that view in datasheet view, then select them all and delete them.  You'd have to do it in batches or up the item limit in the view.
0
 
LVL 6

Expert Comment

by:sabby447
Comment Utility
Try using Quest tool : Sharepoint server admin and you can do all this like you would in windows explorer

0
 

Author Comment

by:City_Of_Industry
Comment Utility
we have Office 2007 Enterprise and only show standard view in our Sharepoint with error message at the bottom "A datasheet component that is compatible with Windows SharePoint Services is not installed".  I checked Microsoft website it said "Support for Windows SharePoint Services list data is available only in Microsoft Office 2003 Professional editions"
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 6

Accepted Solution

by:
sabby447 earned 350 total points
Comment Utility
Oh, I am sure it shows datasheet view, You need MS Access on the system for it show, Try installing Office 2007 on the server and go to datasheet view and you should be able to do that
0
 

Author Comment

by:City_Of_Industry
Comment Utility
Just can't create dataview in Sharepoint Services 3.0 with Office 2007 Ent.

Check our environment, all datasheet components have been installed, ActiveX control and support are enabled. Just like Microsoft website - "Support for Windows SharePoint Services list data is available only in Microsoft Office 2003 Professional editions" - Is it true?

we'd like to have dataview solution - Coding will be considered as a last resort.

0
 
LVL 42

Expert Comment

by:zephyr_hex
Comment Utility
0
 

Author Closing Comment

by:City_Of_Industry
Comment Utility
I only can have dataview on the WSS server but can't have it from my own PC workstation - it is enough for us.

Thank you for all experts comments especially sabby447
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now