.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Taking some SharePoint tables offline only, not all

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :SharePoint
I use MS Access 2007 and SharePoint 2007. I have designed a database that is shared in our group. I am using SharePoint to share the tables. Some tables I would like to keep always online. For performance reasons I would like to take other tables offline and synchronize them from time to time only. Is it possible to take only some SharePoint tables offline, not all? An alternative solution to the problem would be if I can automatically synchronize foreign keys after private keys change when SharePoint comes back online. I haven't found a way to do so. Is there any way to do so? Thanks a lot in advance.

View Complete Post

More Related Resource Links

SharePoint 2010 + RBS.msi does not create tables ("mssqlrbs") at the content DB

Installed on W2K8 SP2 + SQL 2 K 8 R2 CTP November + SPS2010 beta. SQL instance by default MSSQLSERVER and WSS_Content default content database. Step by step following installation and use of remote Blob Storage capacity documentation:http://technet.microsoft.com/en-us/library/ee748631(office.14).aspxThe RBS.msi, at the log file component installation it seems that installation is correct, but displays the error:... Executing op: ActionStart(Name=FixFilestreamStoreConfig,,)Información 2769. El instalador ha encontrado un error inesperado. El código de error es 2769. La acción personalizada CreateFilesNoUI no ha cerrado 21 identificadores MSIHANDLE.... Executing op: CustomActionSchedule(Action=FixFilestreamStoreConfig, ActionType=3070, Source=BinaryData, Target=RepairProvider, CustomActionData=filestream;C:\Program Files\Microsoft SQL Remote Blob Storage10.50\Provider Libraries\Filestream Provider\FilestreamProviderConfiguration.xml)...The content database have not created the necessary tables "mssqlrbs" and running the command in the SharePoint Shell: $ rbss.Installed () returns "False" I have not found a walkarround or anything let me to implement tables and simulate the installation that performs the .msi, provided in the Feature Pack for Microsoft ® SQL Server ® 2008 R2 November Community Technology Preview (CTP)Any h

tracking sharepoint file offline usage

Hi: I am searching for a commercial application which can track SharePoint document usage offline. The sceanrio will be: 1. Download sharepoint ( 2007 or 2010) server hosted document to a laptop.   2. Disconnect the laptop from internet. 3. Access the doucment with difference users. 4. Track who and how many times those documents are accessed. 5. When the laptop is reconnected with intranet, the tracking information from step 4 can be synchronized with Sharepoint server  reporting tools My question is: "is there an out of box application supporting this feature and what are their names?" Thanks a lot.

Sharepoint 2007 page layouts - CSS otr Tables



I've just got into customising my own sharepoint page layouts. I have a good a css background and I've started by just copying the code from the blank web part page or the welcome pages to create my layouts. I notice they are all table based layouts. Is there any reason why I couldn't do purely css based layouts?


How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?


I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.



Silverlight access SharePoint Workspace offline lists


Is it possible to access SharePoint Workspace data from a silverlight out-of-browser application?

We need to have data offline and be able to sync it back later on. Data is stored in external lists and we want to be able to read and write to the external lists offline from a more user friendly GUI such as a Silverlight application. Infopath forms can not do the advanced GUI things we want to do, therefore it is not an option.

How to open More then one lists of sharepoint 2010 as a tables in access 2010 data base


Hi  friends  this is siddiq ,

                                   How can i open sharepoint 2010 lists in access 2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate  database.But i want to take  both the lists  in one access database 

Mohammad Siddiqali

How to take an entire sharepoint site offline and browse ? Does Sharepoint workspace support it?


Hi all,

 I want to take a sharepoint site offline and browse the sharepoint pages.Is it possible with sharepoint workspace?.If not what are the possible ways i can do it?



Gopi Ramaya

- Gopi Ramaya

Working offline on a page SharePoint designer 2007



I am working on a page with SharePoint designer 2007. Page is on MOSS and it is taking very long time in modifying the page. Just wanted to know that is there any way work offline on page once coding is complete then deploy it on server?




Pulling data from SQL tables in a Sharepoint Workflow based on an InfoPath form submission


I'm not sure this is the right forum for this, but here goes:

I'm creating a workflow that kicks off when a user submits an InfoPath form to a form library on a Sharepoint 2007 platform.  The workflow should find the manager of the user that submitted the form from SQL and email that person for approval before the next step is run.  Is this possible in Sharepoint 2007 or is using SQL in a workflow only a feature of Sharepoint 2010?

Thanks in advance

Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Displaying SharePoint lists in Web Parts

When you create a built-in or custom list in Microsoft Windows SharePoint Services, Windows SharePoint Services creates a Web Part, a basic building block of a SharePoint site, to display that list. These Web Parts are called List View Web Parts. Windows SharePoint Services stores List View Web Parts in the site collection Web Part gallery. (The site collection Web Part gallery is the most central gallery of Web Parts for a work group. By default, the gallery name is the name of the site, such as "Our Team Site Web Part Gallery." )

Take a tour of your SharePoint site

What is a SharePoint site for?
A SharePoint site is a Web site that provides a central storage and collaboration space for documents, information, and ideas. A SharePoint site is a tool for collaboration, just like a telephone is a tool for communication, or a meeting is a tool for decision making. A SharePoint site helps groups of people (whether work teams or social groups) share information and work together. For example, a SharePoint site can help you:

Coordinate projects, calendars, and schedules.
Discuss ideas and review documents or proposals.
Share information and keep in touch with other people.

Six easy ways to customize your site using Web Parts in SharePoint

Becoming familiar with Web Part customization techniques gives you a range of page-customization choices. For example, you can customize your site's home page so that it displays the specific information that your team needs. You can rearrange the list items on the home page, add lists, and even change the images on the home page. As you become more familiar with Web Part Page customization techniques, you can build interactive Web Part Pages that makes the data in lists more dynamic and useful, and you can add new Web Parts that provide access to external data and Web services.

Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

Out of the Depths of SharePoint's XML Hell

I described how a new open source tool called sporm significantly simplifies unit testing SharePoint. Making SharePoint unit testable is my absolute favorite feature of sporm because SharePoint is notoriously hard to unit test. But sporm provides other benefits as well and its ability to pull us out of the depths of verbose loosely typed XML hell and into LINQ excellence is next on my list of favorite features. So in this post I'll describe the pre-sporm technique of querying with CAML, how to query data using sporm, and finally how sporm supports SharePoint's unique architecture of allowing multiple content types per list and what that means to you.

Unit Testing SharePoint - Past, Present, and Sporm

As I described in SharePoint: The Wild West of Software Development there is a serious problem when you develop for SharePoint: ensuring quality through unit testing is really, really hard. And that's where a new open source tool just released today called sporm (SharePoint Object Relational Mapper) comes in. While sporm provides many benefits besides simplified unit testing I wanted to focus on this topic first, because sporm's approach, which models the entity framework in the way it supports POCO's, is a unique feature not available with other SharePoint tools like LINQ to SharePoint.

SharePoint Tutorial - Web Parts

A page in SharePoint is comprised of web parts the exist within zones. Web parts are available for just about everything. For example in the page below there are four web part highlighted by different colors. The purple web part displays a short list of the new announcements stored in the annoucements library. The pink web part displays events from a calendar within the site. The green web part displays an image from a location the user specifies. The gray web part displays a list of links from the links list on the site.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend