Access 2003，突然代码失败 [英] Access 2003, sudden code failure

问题描述

下面是我在许多数据库上运行了6年多的代码段。它可以帮助我快速创建表格。今天，没有任何变化，当它到达创建属性行时，如果因错误13而失败，则输入Mismatch。在每个属性行，每个数据库上。


请知道发生了什么。

Below is a section of code that I have been running for over 6 years on many databases. It helps me create tables quickly. Today, with no changes, when it gets to the create property line, if falls over with Error 13, Type Mismatch. On every property line, on every database.

Any idea what is going on please.

展开 | 选择 | 换行 | 行号

推荐答案

Lysander，


我的哀悼！我之前也有这样的事情发生在我身上。你有最近的MS Office更新吗？你提到Access 2003，这种奇怪的行为似乎更适合转换到2007/2010，但不是一个小版本更改（但过去曾经让我感到困惑）。


我确定你有麻烦来找出rs！描述实际上是文本吗？


MS Access的另一个令人头痛的特殊情节....但是什么可以你做？这就是我们得到的全部！

Lysander,

My condolences! I''ve had stuff like this happen to me before, too. Have you had any recent updates to MS Office? You mention Access 2003, and such weird behavior seems to fit more in a switch to 2007/2010, but not a minor version change (but which has bitten me in the past).

I am sure you have troubleshot to find out if rs!Description is, in fact, text?

Another one of the headache-inducing idiotsyncracies of MS Access.... But what can you do? It''s all we got!

没有，没有更新，没有新软件，我加载的最后一件事是一个游戏，6个月前，代码在那之后工作。 Code上周五实际工作了。由于它在所有数据库上都失败了，而不是数据库问题，我的引用都已损坏，或者其他东西搞砸了我的PC。这是我多年来一直使用的关键省时代码。值得庆幸的是，这次我需要创建的表只有12个字段，所以我可以在今天下午手工制作，但是，这真是令人痛苦的谚语。


说明，在桌子上，确实是文字。它说的是这是生了女人的事。或迄今为止的总妊娠等。

Nope, no updates, no new software, last thing I loaded was a game, 6 months ago, and code was working after that. Code actually worked last Friday. As it is failing on all databases, not a database issue, either my references have got corrupt, or something else is screwing up my PC. This is critical time-saving code I have been using for years. Thankfully, the table I need to create is only 12 fields this time, so I can do it manualy this afternoon, but, a real pain in the proverbials.

Description, on the table, is indeed text. It says things like "This is women who have given birth" or "Total Pregnacies so far" etc.

运行调试编译和选项设置，如下所述的常规调试步骤中所述：
>在发布之前（VBA或SQL）代码


我怀疑你没有明确的选项，并且某处有拼写错误;但是，没有剩下的代码只是猜测（^ _ ^）

run the debug compile and option setups as descriped in the general debugging steps as outlined here:
> Before Posting (VBA or SQL) Code

I suspect that you don''t have option explicit set and that there is a typo somewhere; however, without the remaining code that is only a guess (^_^)

这篇关于Access 2003，突然代码失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！