王春海 的BLOG
用户名：王春海
文章数：450
评论数：4739
访问量：7166236
注册日期：
阅读量：5863
阅读量：12276
阅读量：316325
阅读量：1029192
51CTO推荐博文
在安装SharePoint Server 2010的时候，创建的第一个站点是一个“NetBIOS名称”的网站，而这个时候，“我的网站”（或称“个人网站”），也是基于此NetBIOS名称的，例如，如果你的计算机名称是SP2010，则创建的SharePoint网站是http://sp2010，而“我的网站”则是“http://sp2010/my”，如果用防火墙（例如ISA Server）将此网站发布到Internet上，http://sp2010是一个“相对”的名称，可以发布到Internet上，正确的对我提供服务。但“我的网站”则是一个“绝对”的名称，即使发布到Internet上，还是http://sp2010/my，所以，如果要将SharePoint网站及“我的网站”发布到Internet上，必须更改此链接。
在下面的例子中，将“我的网站”的宿主地址由“http://sp2010/my”改为/Sites/Mysite，主要步骤如下：
（1）进入“SharePoint 2010管理中心”，在“应用程序管理→管理Web应用程序”中，创建Web应用程序，名为，并为其创建一个站点。
（2）“应用程序管理→创建网站集”，如图1所示。
图1 创建网站集
（3）在“Web应用程序”中选择“”，指定标题、说明、网站地址，在“选择模板”中，在“企业”中选择“我的网站宿主”，如图2所示
图2 我的网站宿主
（4）创建完成后，在“应用程序管理”中单击“管理服务应用程序”（参考图1），在进入“服务应用程序”后，单击“User Profile Service Application”，如图3所示。
图3 用户个人服务应用程序
（5）在“我的网站设置”中单击“设置‘我的网站’”，如图4所示。
图4 设置我的网站
（6）在“我的网站宿主”中，修改为:80/sites/mysite，如图5所示，这与图2中创建的宿主网站同路径。并在“个人网站位置”中，添加location（也可以是其他名称，这是一个相对路径）。
图5 设置网站宿主与个人网站位置
（7）创建后，在“应用程序管理→管理Web应用程序”中，选中“”，单击“管理路径”，如图6所示。
图6 管理路径
（8）在“定义管理路径”对话框中，在“添加新路径”中，添加location（与图5个人网站位置保持一致），如图7所示。
图7 添加新路径
经过这样设置，以后在的，单击“我的网站”，就可以以新路径访问“个人网站”，如图8所示。
图8 我的网站
图9 我的网站主页
【注意】，我的内容的位置是图5与图7所添加的个人网站位置，如图10所示。
图10 个人网站位置本文出自 “” 博客，请务必保留此出处
了这篇文章
类别：┆阅读(0)┆评论(0)
22:51:31 23:02:42 23:18:12 16:28:37MS Access 2010 integration with SharePoint Foundation 2010
July 28, 2010
By now, you may have heard about the new integration and web database publishing features possible with Microsoft Access 2010 and Microsoft . However, you might find yourself asking, “What about SharePoint 2010 Foundation?”
Here’s some good news. MS Access 2010 and
have some integration points as well (these apply to SharePoint Server 2010 too). In this article, we’ll cover all of the Access 2010 Integration features as they pertain to .
Microsoft Access 2010 Integration Features
Export Data to a SharePoint 2010 List from Access Tables
This nice integration point will create SharePoint lists that correspond to your Access tables and populate them with the Access table data.
NOTE: This has also piqued the interest of our SharePoint 2010 engineering team because it creates a potential migration path from WSS 3.0 to Foundation 2010. Stay tuned for more about this. You can also
about our continuing work to ease the SharePoint 2010 migration pains of our clients.
Ok… on to the features!
Let’s say we have an Access 2010 table with some columns and data.
How to automatically link Access Databases to SharePoint Lists
1.Click the External Data Tab
SharePoint List
2.Next, choose the SharePoint Foundation 2010 site where the new List should be created. Click OK.
Your default browse view should now open up right to your new, automatically-populated SharePoint list full of the data from your MS Access tables!
ADDITIONAL NOTES:
If you try to export to a SharePoint list that already exists, a “_1” will be appended to the list name.
The foreign key relationships are automatically converted to lookup columns between the newly created SharePoint lists. Also, Cascade deletes are kept intact in both Microsoft Access and your SharePoint 2010 site.
To move all your Access 2010 tables to SharePoint and create lists for them, use the “SharePoint” button on the Database Tools Tab (shown below).
SharePoint 2010 List Data into Access 2010 Tables
This feature allows you to do one of two things:
1. Do a one-time import of SharePoint 2010 list data into a new table in a MS Access 2010 database.
2. Create a linked table so that changes to the data in SharePoint or on Access 2010 will be synced.
Here’s an example list of companies in our SharePoint 2010 Foundation site:
We want to work with this data in Access 2010. We can import or link the data between SharePoint Foundation and Access 2010 from 2 SharePoint’s UI or the Access 2010 Client.
Linking SharePoint data to Access 2010 from the SharePoint UI
When viewing our list in a SharePoint Foundation site, click on the “List” tab under “List Tools”, you’ll see the ribbon pictured below – Click on “Open with Access”.
A dialog box pops up (pictured right), asking how you would like to use the data. Choose “Link to data on the SharePoint site”.
This will ensure that data changes from either location are synchronized.
Click “OK”. Access 2010 will be launched (you must have this installed on your workstation).
Access will prompt you for your SharePoint credentials. Once you correctly enter them, you should see your newly created Access table that is being generated from the data in your SharePoint 2010 site.
Now that you’ve linked the data, you have the ability to save a local copy of the Access Database to your workstation for further use.
ADDITIONAL NOTES:
If you are exporting the table, SharePoint cannot overwrite an existing table. You will need to delete the old one and then export the SharePoint list again.
Linking SharePoint Data to Access 2010 from the MS Access Client
1.Now, we’re going to open Microsoft Access 2010 and go to File & New & Blank Database
Give the database a name and click Create.
2. Next, go to the Create Tab, and go to SharePoint Lists & Existing SharePoint List
3.Enter in your site’s domain name and select the “link” option. This way, changes we make within Access 2010 will be reflected in our SharePoint Foundation 2010 site.Important:
If you are working with lists in a SharePoint 2010 sub-site, you must enter in the full URL to the sub site.
4.Select the lists you’d like to work with.
For this example, I’m going to use the “list in SP2010”, a custom list I created.
As you can see below, a new table was created in our MS Access 2010 DB called “List in SP2010”, reflecting the column structure of the existing SharePoint list. All of the data was imported.
You can also add a new row in the table, click save, go back to the SharePoint 2010 list in your browser, and hit refresh. You will see the row that was added via Access 2010.
Pretty cool, eh’?
You can even create an Access 2010 application which runs on your local machine with custom forms and use it to update multiple SharePoint lists simultaneously. The data would then be available to all users of your
How can I tell which tables are linked to SharePoint 2010 from inside the MS Access Client?
The tables with the orange icon and a blue arrow are linked. (pictured below)
While all of these Microsoft Access 2010 integration features for SharePoint 2010 work well in SharePoint Foundation, they are truly supercharged when you step up to
with Access Services from Fpweb.net. SharePoint Server 2010 enables the creation of full Access 2010 applications in the Access client with forms and reports that can be published to your SharePoint server, giving you a user-friendly scalable Access web database that is accessible from anywhere in the world.
VN:F [1.9.22_1171]Rating: 6.2/10 (12 votes cast)
No trackbacks yet.
What Interests You?
Related Posts
Don't Miss a Post!
Subscribe to our blog and each new post will be auto-magically delivered via email.
Subscribe to Our Newsletter
Sign up today for Beside the Point, Fpweb.net's official newsletter, and get in on our latest promotions and news! It's a clever blend of entertainment and information.
Latest Blog Posts
Stay Connected二次元同好交流新大陆
扫码下载App
温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
以无法为有法,以无限为有限！
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
阅读(1713)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_',
blogTitle:'SharePoint Server 2010安装过程',
blogAbstract:'SharePoint Server&2010安装除了需要Windows Server 2008 x64和SQL Server 2008 R2之外，还需要操作系统另外再打很多的补丁（参考文档SharePoint2010安装简介及相关补丁下载）\n\t\t\t\t。本文介绍使用',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:0,
publishTime:8,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:1,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:true,
hostIntro:'以无法为有法,以无限为有限！',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}您所在位置： &
&nbsp&&nbsp&nbsp&&nbsp
Microsoft SharePoint Server 2010 伺服器和伺服器阵列作业指.doc533页
本文档一共被下载：
次 ,您可免费全文在线阅读后下载本文档
文档加载中...广告还剩秒
需要金币：100 &&
你可能关注的文档：
··········
··········
Microsoft SharePoint Server 2010 伺服器和伺服器列作I指南
Microsoft Corporation
l行日期：2011 年 1 月
作者：Microsoft Office System and Servers 小M
本f明如何在 Microsoft SharePoint Server 2010 h境操作和So伺服器及伺服器列，其m用ο蟀括用程式I人T、企II\用程式I人T，以及操作和So SharePoint Server 2010 安b的 IT 管理T。
本包含截至l行日期橹怪 SharePoint Server 2010 技g文件
/fwlink/?linkid 181463&clcid 0x404
的x热荨Ｈ缧枳钚碌热荩㈤W路上的技g文件臁
本文件S依「F睢固峁。本文件所述的Y及^c
包括 URL 及其他WHW路W站⒖
如有更，恕不另行通知。您必自行承使用的LU。
本文所提及之部分例均樘，KH供f明之用。其o意指射或影射任何真的案。
本文件不提供F用θ魏 Microsoft a品之任何智慧a的法定嗬。F用艨梢匝}u本文件，K⑵溆炔⒖肌
? 2011 Microsoft Corporation. All rights reserved.
Microsoft、Access、Active Directory、Backstage、Excel、Groove、Hotmail、InfoPath、Internet Explorer、Outlook、PerformancePoint、PowerPoint、SharePoint、Silverlight、Windows、Windows Live、Windows Mobile、Windows PowerShell、Windows Server 及 Windows Vista 是 Microsoft Corporation 在美及
其他家/地^的]陨嘶蛏恕
本文件所包含的Y代表 Microsoft Corporation 截至l行日期橹梗於所之}的^c。由於 Microsoft 必因多的市霏h境，因此不⑵浣忉 Microsoft 的承Z，Microsoft 不保Cl行日期之後所提供之任何Y完全正_o`。
Operations for SharePoint Server 2010 27
Server and server farm administration
SharePoint Server 2010
SharePoint Server 2010
Prepare to back up and recover
SharePoint Server 2010
Restrictions 30
Requirements 31
How to create a shared folder 32
浞菁驮的最佳作法
SharePoint Server 2010
效能最佳作
正在加载中，请稍后...