打开从Access 2007到Sharepoint的连接 [英] Opening a connection from Access 2007 to Sharepoint

问题描述

大家好。


我正在研究Access 2007上的数据库.Db保存在Sharepoint服务器上，每个用户都有FE .mdb文件，带有表格与Sharepoint相关联。


好​​的，一切正常。每个用户必须在打开文件时登录（访问''安全性），并且当尝试打开表时，窗口会提示对Sharepoint进行身份验证。


现在，我们想要改变一点，我需要绕过Sharepoint的身份验证：我的意思是，我想编写一个代码，使用CurrentUser（）打开与Sharepoint的连接，检查加密表上的传递。


请关于如何打开此连接的任何建议？



PD：我知道这是可能的，因为我已经测试过了它使用两个表，T1和T2。如果用户在两个表上都拥有管理员权限，一旦他在尝试打开T1时登录了Sharepoint，那么他可以在不重新登录的情况下打开T2。 （必须有某种打开连接）

Hi all.

I''m working on a database on Access 2007. Db is kept on a Sharepoint server, and each user has its FE .mdb file, with tables linked to Sharepoint.

Ok, everything''s working fine. Each user has to login when file is opened (Access'' security), and also when tries to open a table, a window prompts for authentication against Sharepoint.

Now, we want to change a little thing, and I need to bypass Sharepoint''s authentication: I mean, I would like to write a code to open a connection against Sharepoint using CurrentUser(), checking for the pass on an encrypted table.

Please, any advice about how to open this connection?



PD: I know it is possible because I have tested it using two tables, T1 and T2. If an user has admin privileges on both tables, once he has logged on Sharepoint while trying to open T1, then he can open T2 without re-login. (There must be some kind of "open connection")

推荐答案

我对此知之甚少但我的理解是使用Sharepoint你需要一个.accdb文件不是.mdb，这就是我升级到2010的原因。

另外，我的理解是Sharepoint只是一个用于存储（a）数据和（b）编译代码的存储库应用程序，其表单，宏等。要进行任何更改，您将更改原始源.accdb然后重新上载，因此可以将修订版下载到用户。


所以我应该注意看到正确的解决方案！

S7

I have limited knowledge of this but my understanding was that to use Sharepoint you needed an .accdb file not .mdb, which is why I upgraded to 2010.

Also, my understanding is that Sharepoint is just a repository for storing (a) the data and (b) the compiled code for the App, its forms, macros etc. To do any changes you would change the original source .accdb then re-upload, so the revision can be downloaded to the users.

So I shall watch this to see the correct solution!
S7

Mikeleroi：

我需要绕过Sharepoint'的身份验证：

Mikeleroi:
and I need to bypass Sharepoint''s authentication:

我希望这会给我们的大多数专家带来红旗。我们不能帮助任何人绕过安全，所以除非你能说服这只是重用已经成功验证的安全连接的要求，否则我怀疑你会得到很多帮助（没有它，任何这样的反应将很快被删除，海报将需要自己解释。


请澄清。

I expect this will throw a red flag for most of our experts. We don''t help anyone to bypass security here, so unless you can convince that this is only a requirement to reuse a security connection that has already been successfully validated, I doubt you''ll get much help (Without it, any such response will be pretty quickly removed anyway and the poster will need to explain themselves).

Please clarify.

Mikeleroi：

我需要绕过Sharepoint的身份验证


抱歉，我的mystake，我没有正确选择这些词，因为我不想绕过这个安全程序。


我只是想尝试建立连接：如果用户打开浏览器，同样的方式，Sharepoint提示用户/通过;当此用户尝试从Access打开链接表时，需要写入user / pass。


如果此用户试图打开另一个表（并且他有权限），它将打开而不重新填写提示。另一方面，如果没有权限，登录提示将再次打开。


Sharepoint的安全性将继续发挥作用;我只想避免第一个登录窗口，使用实际用户并传递（因为我将是管理员，我将设置密码......无论如何，它们将在本地表用户加密 - >传递）。你知道是否可能吗？


编辑：我正在尝试使用链接表的.Connect编写VBA，并添加UID和PWD，但不起作用。


PD：我不是那个设计解决方案的人，那个想这样做的人。


如果不可能，我也想知道，开始寻找替代方案。如果有任何其他安全方法合适，我很高兴你能指出我正确的方向。


感谢您的建议

Mikeleroi:
and I need to bypass Sharepoint''s authentication

Sorry, my mystake, I didn′t choose properly the words as I don′t want to bypass this security procedure.

I just would like to try to establish a connection: the same way if an user opens a browser, Sharepoint prompts for user/pass; same happens when this user tries to open a linked table from Access, needs to write user/pass.

And if this user tries to open another table (and he has privileges), it will open without re-filling the prompt. On the other hand, if doesn′t have privileges, login prompt will open again.

Sharepoint''s security will continue to work; I just would like to avoid the first login window, using actual user and pass (As I would be admin, I will set the passwords... anyway, they will be encrypted on a local table user -> pass). Do you know if is it possible?

I''m trying coding on VBA using .Connect of linked table, and adding it UID and PWD, but doesn′t work.

PD: I''m not the one who designed the solution, the one who did would like to do it this way.

And if it is not possible, I would like to know also, to start looking for alternatives. Please, if there''s any other security method suitable, I would be glad if you could point me in the right direction.

Thank for your advice

这篇关于打开从Access 2007到Sharepoint的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！