SharePoint Access数据库，能吸引用户吗? [英] SharePoint Access Database, get users?

问题描述

是否有一种简单(任何)方法可以在SharePoint中创建数据库(我正在使用MS Access对其进行编辑)并具有指向SharePoint用户列表的链接表?

Is there a simple (any) way to create a database within SharePoint (I'm editing it with MS Access) and have a linked table to SharePoint's user list?

我想修改内置示例问题数据库"以不使用其自己的用户表，而是使用SharePoint的用户表.

I want to modify the builtin sample "Problem database" to not use its own User table but to use SharePoint's user table.

推荐答案

您始终可以链接到用户表，并且可以对发布的任何应用程序进行链接.

You can always link to the user table, and you can do so for any application you publish.

即使对于未发布的(网络)应用程序，您也可以执行此操作.

And you can do this even for non published (web) applications.

您可能必须删除现有的用户表(以便测试/尝试复制).

You may well have to delete the existing user table (so test/try on a copy).

要链接，您首先需要的是当前已发布应用程序的URL.假设此文件在Access中打开，然后在命中文件中打开，然后向您展示后台，并且在两个位置中可以看到发布站点的URL.请注意，绿色的是一个可以单击的超链接(我经常使用它来确保我在浏览器中启动正确的网站).

To link, the first thing you need is the URL of the current published application. Assuming this is open in Access, then hit file, then you are presented with back stage and there are TWO places in which you can see the URL to the published site. Note how the one in green is a hyperlink that you can click on (I use that often to ensure I launch the correct web site in my browser).

但是，我们需要执行剪切+粘贴操作，因此请注意上面蓝色的URL.您可以单击该URL并将其突出显示，然后右键单击该URL并将其复制"到粘贴缓冲区中.

However, we need to do a cut + paste, and thus note the URL in blue above. You can click on that URL, highlight it, and then right click and "COPY" the URL into your paste buffer.

现在从主页上，只需链接到SharePoint网站上的表.在外部数据"选项卡中，选择"SharePoint"列表.

Now from the main page, simply link to the table on the SharePoint site. From the External data tab, choose SharePoint list.

现在，粘贴您的URL(您可以键入，但是，这太麻烦了！).

Now, paste in your URL (you could type, but hey that too much work!).

现在，当表列表显示出来时，您会看到以下内容:

Now, when the list of tables shows up, you see this:

从上面选择用户信息表.

From the above choose the user info table.

这将用您的用户表替换"您发布的表.此技巧适用于Access中基于Web的应用程序和基于非Web的应用程序.

This will "replace" your published table with that of the user table. This tip works for both web and non web based applications in Access.

Albert D. Kallal(访问MVP)

Albert D. Kallal (Access MVP)

加拿大艾伯塔省埃德蒙顿

Edmonton, Alberta Canada

这篇关于SharePoint Access数据库，能吸引用户吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！