设置后端表和前端查询之间的关系 [英] Setting up relationships between back-end tables and front-end queries

问题描述

您好 -


我有一个Access 2010数据库，它有一个前端和一个后端。两者都位于我们服务器上的共享文件夹中。


我正在努力完成将此数据库发布到SharePoint 2010的过程。


当我运行Web兼容性检查器时，我得到了以下错误：

与有效查阅字段无关的关系与Web不兼容。


这些错误（ 3）都与一个名为Q_COMPANYDATA的查询相关联，该查询基于我们的SQL服务器上的ODBC链接表。


元素类型：关系

元素名称： Q_COMPANYDATA.COMP_ID< - > T_ACTIVITIES.COMP_ID

控制类型：关系

控制名称：Q_COMPANYDATA.COMP_ID< - > T_ACTIVITIES.COMP_ID


如何在后端与前端的查询建立关系？


我尝试创建查询和前端的链接表。


我也尝试将查询移到后端并在那里建立关系。这两种选择都没有用。


感谢您的任何提示！

Sandra

Hello -

I have an Access 2010 database that has a front end and a back end. Both are located in a shared folder on our server.

I am trying to work through the process of publishing this database to SharePoint 2010.

When I run the Web Compatibility Checker, I get the following errors:

Relationships that are not associated with a valid lookup field are incompatible with the Web.

These errors ( 3 ) are all associated with one query called Q_COMPANYDATA that is based on ODBC-linked tables on our SQL server.

Element Type: Relationship
Element Name: Q_COMPANYDATA.COMP_ID<-->T_ACTIVITIES.COMP_ID
Control Type: Relationship
Control Name: Q_COMPANYDATA.COMP_ID<-->T_ACTIVITIES.COMP_ID

How do I set up a relationship in the back-end to a query that is in the front end?

I tried creating the relationships between the query and the linked tables in the front end.

I also tried moving the query to the back end and setting up the relationships there. Neither option worked.

Thanks for any tips!
Sandra

推荐答案

很难说是什么从提供的信息继续使用您的数据库。


您的查询可以从SQL服务器中提取数据吗？


请看一下： http://bytes.com/topic/access/answer .. .ds-tables-evil

这里有一个compat错误列表......它是MS ...所以信息可能是正确但无用的：
http://office.microsoft.com/en-us/ac...010379061.aspx

请看：ACCWeb105016


- 看来你必须创建一个查找字段......我怀疑在查询中，表格是在SQL服务器中而SQL不在如果我没记错的话，请支持表级的查找字段。


-Z

It is hard to tell what is going on with your database from the information provided.

Can your queries pull the data from the SQL server?

take a look at:http://bytes.com/topic/access/answer...ds-tables-evil

Here''s a list of compat errors... it''s MS... so the info might be correct but useless:
http://office.microsoft.com/en-us/ac...010379061.aspx
Look at: "ACCWeb105016"

- It appears that you will have to create a lookup field... I suspect in the query given that the tables are in the SQL server and SQL doesn''t support lookup fields at the table level if I remember correctly.

-Z

你好Z -


我确实查了ACCWeb105016错误，但正如你所说，不是很有帮助。


是的，查询确实从服务器提取数据。


我也在将整个数据库移动到SQL服务器，因此无论如何在迁移后处理这个问题可能是有意义的。


谢谢！

Hello Z -

I did look up the ACCWeb105016 error, but as you say, not very helpful.

Yes, the query does pull the data from the server.

I am also in the process of moving the entire database to an SQL server so it probably makes sense to deal with this after the migration anyway.

Thanks!

Sandra，


当你打开查询时，你有下拉菜单吗？表格中的（组合框）列表中的[Comp_ID]或只是计划旧框？只是为了确保我很清楚...这是你直接打开查询... 不是表格。如果您有计划旧的标准数据输入字段框，那么从查询设计中，右键单击字段，属性，有一个查找选项卡，您可以尝试设置查找信息。

-z

Sandra,

When you open the query, do you have a dropdown (combobox) list in the table for the [Comp_ID] or just a plan old box? Just to make sure I''m clear... this is when you directly open the query... not a form. If you have the plan old standard data entry field box, then from the query design, right click the field, properties, there is a lookup tab, that is where you might try and set your lookup information.

-z

这篇关于设置后端表和前端查询之间的关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！