如何指定某些表格，区别于其他表格？ [英] How to earmark certain tables, differentiating them from others?

问题描述

拥有一个包含100个或更多表格的数据库。

想设置一些属性来标记那些

，这些数据来自那些表格是动态的

包含基本上静态的参考数据。


推荐的方法是什么？ Am $ / $
寻找除表格中嵌入的一些独特

字符串以外的方法。

解决方案

< BLOCKQUOTE> 1。使用数据库窗口的描述字段，可以通过

访问，右键单击表名并选择属性。


2.做你做的不想这样做，并在表格名称中添加一些独特的

字符串，例如lu_，如lu_state_code


-

Darryl Kerkeslager


" MLH" < CR ** @NorthState.netwrote

拥有一个包含100个或更多表的数据库。

想要设置一些属性来标记那些

的数据来自那些表格的动态

基本上包含静态参考数据。

MLH写道：

对此推荐的方法是什么？ Am $ / $
寻找除表格中嵌入的一些独特的

字符串以外的方法。

Hon，推荐的方法*是*使用表名的一部分，比如

Bldg_Lkup或Bldg_Local或Bldg_Lcl，用于前端桌。您可以使用实用程序来更改整个应用程序中的名称，或者您可以在每个表中添加一个表属性并在代码中读取该属性 >
以确定它是否特别。


-

通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/对于... ccess / 200611/1

设置后无法阅读Description属性

按照你的建议。我确实喜欢你的b / b
推荐。这是我试图用
用来阅读描述的代码。当然，它不是工作的b $ b ...


Sub TableDefX（）

Dim MyDB As Database

Dim MyTDF As TableDef

设置MyDB = CurrentDb


使用MyDB

Debug.Print。 TableDefs.Count& _

" TableDefs in &安培; .Name


''枚举TableDefs集合。

For Each MyTDF In .TableDefs

Debug.Print" " &安培; MyTDF.Name& " ==" &

MyTDF.Properties.Description

下一个MyTDF

结束


结束Sub

Have a database with 100 or more tables.
Would like to set some property to flag those
whose data is dynamic from those tables
containing essentially static reference data.

What''s recommended method for this? Am
looking for a method other than some unique
string embedded in table name.

解决方案

1. Use the Database Window''s Description field, which is accessible by
right-clicking on the table name and choosing Properties.

2. Do what you don''t want to do, and add "some unique
string embedded in table name", like "lu_", as in, "lu_state_code"

--
Darryl Kerkeslager

"MLH" <CR**@NorthState.netwrote

Have a database with 100 or more tables.
Would like to set some property to flag those
whose data is dynamic from those tables
containing essentially static reference data.

MLH wrote:

What''s recommended method for this? Am
looking for a method other than some unique
string embedded in table name.

Hon, the recommended method *is* to use part of the table''s name, like
Bldg_Lkup or Bldg_Local or Bldg_Lcl, for the front end tables. You can
either use a utility to change the names throughout the application or you
can add a table property to each of the tables and read that property in code
to determine if it''s special.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

Am having trouble reading the Description property
after setting it as you recommended. I do like your
recommendation, BTW. Here''s the code I tried to
use to read the description. Of course, it is not
working...

Sub TableDefX()

Dim MyDB As Database
Dim MyTDF As TableDef
Set MyDB = CurrentDb

With MyDB
Debug.Print .TableDefs.Count & _
" TableDefs in " & .Name

'' Enumerate TableDefs collection.
For Each MyTDF In .TableDefs
Debug.Print " " & MyTDF.Name & " ==" &
MyTDF.Properties.Description
Next MyTDF
End With

End Sub

这篇关于如何指定某些表格，区别于其他表格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！