创建具有比Fieldname，Length，Type更多属性的表 [英] Creating A Table With More Properties Than Fieldname, Length, Type

问题描述

我有一个数据库，如果它不存在我需要创建一个表。这是我目前的代码：

I have a database, where I need to create a table if it doesn''t exist. This is my code at the moment:

展开 | 选择 | Wrap | 行号

推荐答案

表一旦表创建关闭记录集，然后重新打开如下：

Once the table has been created close the recordset and then reopen as follows:

展开 | 选择 | Wrap | 行号

这正是我想要的！我在SQL中找到了另一种方法，即将发布它，但你的方式同样好......你知道任何网站提供了访问接受的属性值列表吗？它们都在提供的帮助文档中吗？


在xp上使用Access''03

That is exactly what I want! I found an alternative method in SQL and was just about to post it but your way is equally good...do you know of any websites that give a list of the property values accepted by access? are they all in the help documentation provided?

Using Access ''03 on xp

这正是我想要的！我在SQL中找到了另一种方法，即将发布它，但你的方式同样好......你知道任何网站提供了访问接受的属性值列表吗？它们都在提供的帮助文档中吗？


在xp
上使用Access''03

That is exactly what I want! I found an alternative method in SQL and was just about to post it but your way is equally good...do you know of any websites that give a list of the property values accepted by access? are they all in the help documentation provided?

Using Access ''03 on xp

不知道一个副手，但看看表设计中的属性列表。这将是一个很好的指导方针。保留单词之间的空格（例如DefaultValue）。

Don''t know one off-hand but have a look at the properties list in table design. This would be a good guideline. Leave the spaces between the words out (e.g. "DefaultValue").

这篇关于创建具有比Fieldname，Length，Type更多属性的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！