升迁数据库 - 表单上的无法控制的控制源 [英] Upsized Database - uneditable control source on form
问题描述
大家好，
我最近尝试使用Access Upsizing Wizard升级数据库。我遇到了数据类型的标准问题，并且必须重建一些没有升级的查询。但是，我的一个表格有问题。表单的控件源是基于两个一对一关系表的查询。每个表的记录集都是可编辑的。但是，查询的记录集不是。因此，我的表单无法正常工作。有关使大小查询的记录集可编辑的任何提示吗？
谢谢，
Josh
PS I需要将另一种形式的代码从DAO更改为ADODB。任何人都知道有任何好的在线资源，所以我可以学习一些ADODB命令吗？
Hello all,
I recently tried upsizing a DB with the Access Upsizing Wizard. I ran into the standard problems with datatypes and have to rebuild some queries that didn''t get upsized. I am having a problem with one of my forms, however. The control source of the form is a query based on two tables that are in a one-to-one relationship. Each table''s recordset is editable. However, the query''s recordset is not. Thus, my form is not working correctly. Any tips on making an upsized query''s recordset editable?
Thanks,
Josh
PS I need to change some of by code in another form from DAO to ADODB. Anyone aware of any good online resources so I can learn some of the ADODB commands?
推荐答案
这个问题的标准解决方案是使用（数据表或（单））具有相关记录集的子表单。
将JOINed查询作为表单的记录源总是有风险的。
Nic; o ）
The standard solution to this problem is to use a (datasheet or (single) form) subform with the related recordset.
It''s always risky to have a JOINed query as a form''s recordsource.
Nic;o)
你可以发布查询的SQL和表的元数据。
这是一个如何发布表元数据的例子：
发布表/数据集元数据
Can you post the SQL for the query and the MetaData for the tables.
Here is an example of how to post table MetaData :
Posting Table/Dataset MetaData
PS我需要在另一个代码中更改一些代码从DAO到ADODB的形式。任何人都知道任何好的在线资源，所以我可以学习一些ADODB命令？
PS I need to change some of by code in another form from DAO to ADODB. Anyone aware of any good online resources so I can learn some of the ADODB commands?
我真的只是使用帮助系统。那里有大量的信息。
I would really just use the Help system. There''s whole heaps of info in there.
这篇关于升迁数据库 - 表单上的无法控制的控制源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
