导出到SharePoint时，Access 2007会锁定 [英] Access 2007 locks up when exporting to SharePoint

问题描述

我有一个在select语句中有一个VBA函数的查询（从子表创建一个逗号分隔的列表）。每当我尝试将该查询的结果导出到SharePoint列表时，Access崩溃。我得到Microsoft Access遇到问题，需要关闭。我们对造成的不便很抱歉。当我从select语句中取出此函数时，导出有效。如果我只是返回查询的结果，或者即使我在报表中使用查询，该函数也能正常工作。


有什么想法吗？


谢谢


Joe

解决方案

这是一个非常含糊的描述。

很可能你正在转移一些不同的东西：


请发布查询的SQL - 记得使用< CODE />格式化它按钮。

接下来我们需要构建查询的基础表的结构...请使用以下内容：


名称：tbl_exampletablename

[examplfieldname_PK] autonumber主键

[examplefieldname_somename] text（50）-notindexed，required

[examplefieldname_yan] long

[FK_example] long; foriegn key 1：M with tbl_someothertablename


请同时记下表格中的任何查找字段并发布其基础记录来源。


我们可能还需要用于传输的代码（如果有的话）。

您似乎认为它与您的函数调用有关。因此，首先检查是否是这种情况。将当前查询更改为生成表查询，在数据库中创建本地表。然后将该表导出到SharePoint。如果它导出正常，那么你很可能是正确的，也许函数调用是问题的一部分（我没有在这一点上指出的SharePoint体验）。


如果查询没有导出，那么可能是您遇到了不兼容的数据类型问题，因此您可以查看它。


问题解决（和调试）的第1步通常是为了确保你将问题缩小到根本原因。

< blockquote> @TheSmileyCoder


是的，我确实将它缩小到函数调用。我删除了函数调用并替换为硬编码的逗号分隔字符串，它可以工作。


对于另一张海报，这是我的查询：

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

I have a query that has a VBA function in the select statement (creates a comma delimited list from a child table). Whenever I attempt to export the results of that query to a SharePoint list, Access crashes. I get the "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. When I take this function out of the select statement, the export works. The function works fine if I just return the result of the query or even if I use the query in a report.

Any ideas?

Thanks

Joe

解决方案

That is a very vague description.
More than likely you''re transfering something that sharepoint doesn''t like so:

Please post the SQL of the query - remember to format it using the <CODE/> button.
Next we need the structure of the underlying tables that the query is built on... please use something along these:

Name: tbl_exampletablename
[examplfieldname_PK] autonumber primary-key
[examplefieldname_somename] text(50)-notindexed, required
[examplefieldname_yan] long
[FK_example] long; foriegn key 1:M with tbl_someothertablename

Please also make note of any lookup-fields in the tables and post their underlying record source(s).

We may also need the code, if any, being used to transfer.

You seem to think its related to your function call. So start by checking whether that is the case. Change your current query to a make table query, making a local table in your database. Then export that table to SharePoint. If it exports fine, then chances are you are right and maybe the function call is part of the problem (I don''t have SharePoint experience I should point out at this point).

If the query doesn''t export then it might be that you have issues with incompatible datatypes, so you can look into that.


Step 1 of problem solving (And debugging) is usually to make sure you have narrowed down the problem to the root cause.

@TheSmileyCoder
Yeah, I do have it narrowed down to the function call. I have removed the function call and replaced with a hard coded comma delimited string and it works.

To the other poster, here is my query:

Expand|Select|Wrap|Line Numbers

这篇关于导出到SharePoint时，Access 2007会锁定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！