DAO - 哪些属性适用于每种字段类型？ [英] DAO - which properties apply to each field type?

问题描述

大家好，


我正在开发一个可以在MS中构建数据库对象的应用程序

从文本文件访问。我想你可以称之为备份和

恢复类型例程。


访问字段，表格，关系和索引是没有问题的
通过DAO代码为我
。我遇到的问题是，我不确定哪些

属性实际上是必需的/可用于从每个

可能类型的字段的代码设置。我已经看过这个参考了，但是

找不到具体的这个任务。


我要找的是一个简单的网格 ;甚至，那将是沿着网格一侧的Jet

字段属性，以及另一个

字段类型（例如dbBoolean，dbInteger等...），并标明哪些

适用于哪种类型的字段。


是否有人有此类信息或我可以获得的信息？它会给我节省很多时间。


欢呼和谢谢


青蛙。

Hello everyone,

I am working on an application that can build database objects in MS
Access from text files. I suppose you could call it a backup and
restore type routine.

Accessing the fields, tables, relationships, and indexes is no issue
for me via DAO code. The issue I have is that I am not sure which
properties are actually necessary / available to set from code for each
possible type of field. I have looked fo′r a reference on this, but
cannot find one for specifically this task.

What I am looking for is a simple "grid" even, that would have Jet
Field Properties along one side of the grid, and along the other the
field types (eg dbBoolean, dbInteger, etc...), and marking off which
ones apply to which field type.

Does anyone have this type of information or where I can get it? It
would save me many hours of playing around.

Cheers and Thanks

The Frog.

推荐答案

2006年12月6日06:46:37 -0800，青蛙 < a ************** @ eu.effem.comwrote：

On 6 Dec 2006 06:46:37 -0800, "The Frog" <an**************@eu.effem.comwrote:

>大家好，
<我正在开发一个可以在MS中构建数据库对象的应用程序
从文本文件访问。我想你可以把它称为备份和恢复类型例程。

通过DAO代码访问字段，表，关系和索引对我来说没有问题。我遇到的问题是，我不确定从每个可能的字段类型的代码设置实际上需要/可用的属性。我已经看过这方面的参考，但
找不到具体的任务。

我正在寻找的是一个简单的网格。甚至，那将在网格的一侧有Jet /> Field Properties，另外还有
字段类型（例如dbBoolean，dbInteger等等），并标记出哪些
哪些适用于哪种类型的字段。

有没有人有这种类型的信息或我可以获得它？它会让我节省很多时间玩耍。

干杯和谢谢

青蛙。

>Hello everyone,

I am working on an application that can build database objects in MS
Access from text files. I suppose you could call it a backup and
restore type routine.

Accessing the fields, tables, relationships, and indexes is no issue
for me via DAO code. The issue I have is that I am not sure which
properties are actually necessary / available to set from code for each
possible type of field. I have looked fo′r a reference on this, but
cannot find one for specifically this task.

What I am looking for is a simple "grid" even, that would have Jet
Field Properties along one side of the grid, and along the other the
field types (eg dbBoolean, dbInteger, etc...), and marking off which
ones apply to which field type.

Does anyone have this type of information or where I can get it? It
would save me many hours of playing around.

Cheers and Thanks

The Frog.

你可以节省更多的游戏时间 -

http://www.ffdba.com/downloads/Save_...ts_As_Text.htm

Wayne Gillespie

Gosford NSW澳大利亚

You can save many more hours of playing around by going to -

http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
Wayne Gillespie
Gosford NSW Australia

嗨Wayne，


欣赏这个想法，但链接不起作用。你是否正确输入了

的链接？


我有几种类型的实用工具，但大多数都忽略了

字段属性。我需要捕获字段属性来为我们的应用程序执行此操作。我们在这个

应用程序上构建了大量的依赖项，我需要绝对肯定我确实需要所有需要的东西，没有猜测或可能的疏忽。


您是否有机会重新发布/检查您提供的链接？

Hi Wayne,

Appreciate the idea, but the link doesnt work. Did you type the link
correctly?

I have several of these types of utilities, but mostly they ignore the
field properties. I need to capture the field properties to do this for
our application. We have a large number of dependencies built on this
application, and I need to be absolutely certain that I have exactly
everything that is needed, no guesswork or possible oversights.

Any chance you might be able to re-post / check the link you provided?

"青蛙 < a ************** @ eu.effem.com写在

新闻：11 *************** *******@l12g2000cwl.googlegr oups.com:

"The Frog" <an**************@eu.effem.comwrote in
news:11**********************@l12g2000cwl.googlegr oups.com:

嗨Wayne，


赞赏这个主意，但链接不起作用。你输入了正确的链接

了吗？

Hi Wayne,

Appreciate the idea, but the link doesn?t work. Did you type the link
correctly?

链接（ http://www.ffdba.com/downloads/Get_Object_Names.htm ）有效但

这不符合您的要求。 [谢谢，Wayne提到它。]


您提到备份;我想你想要文档。

虽然提到的实用程序创建了所有Access和

VBA对象的文本表现形式，但是JET对象没有这样做，它们只是支持 -

up。


如果我做的事情（我认为）你想做的话我会用

ADO。我意识到那些不熟悉ADO的人说它不会做任何事情，但DAO不会这样做，而且我同意在最初的几百个优势之后

它是'很难找到更多;但这是前几百个之一。


如果你去
http://www.ffdba.com/columns.asp


然后点击全部然后提交你会得到一个想法ADO可以简单快速地提供有关表格的那种

信息。 （这个

是一个动态页面;即每次加载
时它会重新获取信息。


如果你去
http://www.ffdba.com/procedures.asp


您将看到ADO如何列出所有查询（sprocs），视图等。


您将看到的页面（如果您可以在链接上单击两次，即，使用ASP / Javascript和ADO创建
并引用MS-SQL数据库。

但是所有程序都是完全可以使用Access，VBA和JET

数据库。当然，不是将信息显示为HTML

页面，而是将其保存到文件中。

http://www.ffdba.com/downloads/Get_Object_Names.htm 不完整

解决方案，但它可能会给你一个开始。


只是循环通过DAO定义这样做的想法是痛苦的

我。 ADO将立即无痛地为您提供所需信息。


-

Lyle Fairfield


来自< a rel =nofollowhref =http://msdn.microsoft.com/library/default.asp?url=/library/en-target =_ blank> http://msdn.microsoft.com/library /de...l=/library/en-

us / dnmdac / html / data_mdacroadmap.asp


过时的数据访问技术

过时的技术是在几个产品版本中未得到增强或更新的技术，将被排除在未来的产品版本之外。在编写新的

应用程序时，请勿使用这些技术。当您使用这些技术修改使用这些技术编写的现有应用程序时，请考虑将这些应用程序迁移到

ADO.NET。

考虑以下组件已过时：

....

数据访问对象（DAO）：DAO提供对JET（Access）数据库的访问。

此API可以可以从Microsoft Visual Basic？，Microsoft Visual C ++？，

和脚本语言中使用。它包含在Microsoft Office 2000和

Office XP中。 DAO 3.6是该技术的最终版本。它不会在64位Windows操作系统上提供
。

.....

The link (http://www.ffdba.com/downloads/Get_Object_Names.htm) works but
this does not do what you want. [Thanks, Wayne for mentioning it.]

You mentioned backup; I think you want documentation.
While the utility mentioned creates text manifestations of all Access and
VBA objects it does not do so with JET objects, which are simply backed-
up.

If I were doing something such as (I think) you want to do I would use
ADO. I realize that those unfamiliar with ADO say that it will do nothing
that DAO won''t do and I agree that after the first few hundred advantages
it''s difficult to find more; but this is one of the first few hundred.

If you go to
http://www.ffdba.com/columns.asp

and click All and then Submit you will get an idea of the kind of
information that ADO can provide simply and quickly about Tables. (This
is a dynamic page; that is it gets the information anew each time it is
loaded).

If you go to
http://www.ffdba.com/procedures.asp

you will see how ADO can list all queries (sprocs), views etc.

The pages you will see (if you can click twice on the links, that is,)
are created with ASP/Javascript and ADO and reference an MS-SQL database.
But all the procedures are entirely doable with Access, VBA and a JET
Database. Of course, instead of presenting the information as an HTML
page, one is likely to save it to a file.

http://www.ffdba.com/downloads/Get_Object_Names.htm is not a complete
solution for this but it may give you a start.

Just the idea of looping through DAO definitions to do this is painful to
me. ADO will give you the information you need instantly and painlessly.

--
Lyle Fairfield

from http://msdn.microsoft.com/library/de...l=/library/en-
us/dnmdac/html/data_mdacroadmap.asp

Obsolete Data Access Technologies
Obsolete technologies are technologies that have not been enhanced or
updated in several product releases and that will be excluded from future
product releases. Do not use these technologies when you write new
applications. When you modify existing applications that are written
using these technologies, consider migrating those applications to
ADO.NET.
The following components are considered obsolete:
....
Data Access Objects (DAO): DAO provides access to JET (Access) databases.
This API can be used from Microsoft Visual Basic?, Microsoft Visual C++?,
and scripting languages. It was included with Microsoft Office 2000 and
Office XP. DAO 3.6 is the final version of this technology. It will not
be available on the 64-bit Windows operating system.
.....

这篇关于DAO - 哪些属性适用于每种字段类型？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！