AC.2013（表）属性值太大 [英] AC.2013 (Table) property Value is too large

问题描述

Table.Design

Hi, Table.Design

移动一些列，....

move some columns,....

是否要将更改保存到布局表....是

Do You Want To Save Changes To The Layout Of Table....YES

错误：属性值太大......

ERROR: property Value is too large......

Sub ADHOC_TABLE_FIELDS_PROPERTY_VAL_LEN_CHECK()
On Error Resume Next
Dim i As Long, i2 As Long, lc1 As String, lc0 As String, lc_TT As String
lc_TT = "ZZ_TBL_INI_W1_DFT"
Debug.Print lc_TT
For i2 = 0 To CurrentDb.TableDefs(lc_TT).Fields.Count
For i = 0 To CurrentDb.TableDefs(lc_TT).Fields(i2).Properties.Count
    lc1 = i2 & "." & i & ", FLD.NAME=" & CurrentDb.TableDefs(lc_TT).Fields(i2).Name & ", PROP.NAME=" & CurrentDb.TableDefs(lc_TT).Fields(i2).Properties(i).Name
    lc0 = ""
    lc0 = CurrentDb.TableDefs(lc_TT).Fields(i2).Properties(i).Value
    lc1 = lc1 & ", PROP.LEN=" & Len(lc0) & ", PROP.VAL=" & lc0
    If Len(lc0) > 150 Then Debug.Print lc1
Next i
Next i2
End Sub

70.22，FLD.NAME = V1，PROP.NAME =说明，PROP.LEN = 162，PROP.VAL = V1：     V＃NE-FAR ......

70.22, FLD.NAME=V1, PROP.NAME=Description, PROP.LEN=162, PROP.VAL=V1:     V# NE-FAR......

属性值太大....属性值MAX LENGHT = ............ 162（ 162太多了？）

property Value is too large....property Value MAX LENGHT =............162 ( 162 is too much ?)

dBase，FoxPro，MS Access 2003，（2010 = Not rec。），Office 2010 + ACC.2013，Symbian C ++， AC.2013.SystemResource.GetCurrentFreeSize =？

dBase,FoxPro,MS Access 2003,(2010=Not rec.),Office 2010+ACC.2013 ,Symbian C++, AC.2013.SystemResource.GetCurrentFreeSize=?

推荐答案

2cryptic

2cryptic

您的代码无法证明任何事情，因为财产价值没有得到保存。

Your code does not prove anything, because the property value did not get saved.

我们需要一个可靠的可重现方案。这样做：

We need a solid reproducible scenario. Do this:

1。创建一个新的空数据库，将有问题的表复制到它（仅限结构）。

1. create a new empty database, copy the table in question to it (structure only).

2。将问题减少到最少的步骤。

2. Reduce the problem to the minimal number of steps.

3。运行psr.exe并记录这些步骤。

3. Run psr.exe and record those steps.

4。将数据库和psr输出发布到公共场所，例如免费的OneDrive帐户。

4. Post the database and the psr output to a public place, like a free OneDrive account.

这篇关于AC.2013（表）属性值太大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！