表格不再允许编辑 [英] Form no longer allows editing

问题描述

大家好，


除此之外，我还维护了一个Access应用程序，我从大约六个以前的维护者那里继承了这个应用程序。 :(


我接到一位用户的电话，其中一个表格不再允许编辑数据。也就是说，你可以点击框中的，但是可以不要更改它们中出现的数据。光标移动到你点击的位置，它位于那里并闪烁，但是当你尝试输入或删除时，没有任何反应。


数据驻留在SQL Server上，Access片段是一个前端，包含表格和查询以及表格链接。我下拉了Linked-Table Manager并刷新了所有链表。这没有用。


我检查了受影响文本框的属性。它们已启用且未锁定。我的网络搜索中出现的另一个想法是某些查询无法更新。令我感到震惊的是，如果没有我的更改实现它，改变的元素可以很容易地作为表单的查询，所以我检查了。我得到了旧版本的Access数据库（前端）并检查了相应的表格o那个。字段是可编辑的。然后，我从数据库的两个版本的表的记录源查询中复制SQL，并通过WinMerge（diff实用程序）运行它们，它们报告它们是相同的。


我还使用了Tools | Analyze | Documenter来创建旧版本和新版本的表单描述。我选择了选项中的所有内容并将它们导出到.txt文件中，然后将它们与WinMerge进行比较。除了几个月前我做过的一个小的措辞变化之外，唯一的其他差异是许多地方，其中一些先前的维护者已经将几个变量的情况从低到高改变了。否则没什么。


我的想法已经用完了。你们中的任何人都有我的线索吗？还有什么可能导致这种行为？


谢谢，

Paul

解决方案

< ol style =list-style-type：decimal>

我会得到基础查询（或SQL无论如何）并直接打开它。然后测试它是否仍然可以更新。

检查表单的每个属性和相关控件，看看是否有任何意外导致了这个问题。

这就是我的全部现在可以想到，因为（＃1）也涵盖了从Access更新SQL Server数据的任何潜在问题（我最近经历过大型更新和缺少资源的SQL Server）。

您好NeoPa，


感谢您的建议。我最终只回滚了一个版本，这已经足够了，然后重新编写了最新版本。我仍然不知道那个表格出了什么问题或为什么，这让我感到困扰，但是在浪费了几个小时试图理解它之后，我认为是时候继续前进了。


非常感谢，

Paul

显然是一个有智慧的人保罗:)


什么时候放手尝试不同的路线通常很难看。

Hi all,

Among other things, I maintain an Access application that I have inherited from about a half-dozen previous maintainers. :(

I got a call from one of the users to the effect that one of the forms no longer allows editing of data. That is, you can click in the box, but can''t change the data that appears in them. The cursor goes where you click, it sits there and blinks, but when you try to type or delete, nothing happens.

The data resides on a SQL Server with the Access piece being a front-end containing forms and queries with links to the tables. I pulled down the Linked-Table Manager and refreshed all the linked tables. That didn''t help.

I checked the properties of the affected textboxes. they are Enabled and NOT Locked. Another idea that came up in my web search was that some queries are not updatable. It struck me that if something changed without my realizing it, the element that changed could as easily be the query as the form, so I checked that. I got an old version of the Access database (front-end) and checked the corresponding form on that. The fields were editable. I then copied the SQL from the record-source query for the table from both versions of the database and ran them through WinMerge (a diff utility), which reported that they are identical.

I also used Tools|Analyze|Documenter to create descriptions of the form from the old and new versions. I selected everything in the options and exported them both to .txt files and then compared them with WinMerge. Aside from one small wording change that I had made several months ago the only other differences were a number of places where some previous maintainer had changed the case of several variables from lower to upper. Otherwise nothing.

I''ve about run out of ideas. Do any of you folks have any clues for me? What else might cause this kind of behavior?

Thanks,
Paul

解决方案

1. I would get the underlying query (or SQL whatever) and open it directly. Then test that it is still updatable.
2. Check through each property of the form and the relevant controls to see if anything unexpected has caused the issue.

That''s all I can think of for now, as that (#1) also covers any potential problem updating data of the SQL Server from Access (which I have experienced recently with large updates and a SQL Server running short of resources).

Good luck!

Hi NeoPa,

Thanks for your advice. I eventually just rolled back by one version, which was enough, and then redid the latest change. I still have no clue what went wrong with that form or why, and that bothers me, but after wasting hours trying to make sense of it, I figured that it was time to move on.

Thanks a lot,
Paul

Clearly a man of wisdom Paul :)

When to let go and try a different route is often a hard thing to see.

这篇关于表格不再允许编辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！