关于将数据库对象保存为文本文件并导入它们... [英] Regarding saving database objects as text files and importing them...
问题描述
GHudson的工作程序发布在
http://www.access-programmers.co.uk/...ad.php?t=66320
他们工作。但是，关系和一些次要的默认设置是不保留的。
。重新建立一些默认设置和设置是一个很小的价格来支付一组文本文件可以保存您的数据库
从总损失＃AND＃似乎删除数据库同样膨胀。
我想知道是否有人知道如何保持关系
作为文本文件，所以他们不必从头开始重建
导入表之后。
GHudson has working procedures posted at
http://www.access-programmers.co.uk/...ad.php?t=66320
They work. Relationships, however, and some minor default settings are
not preserved. Reestablishing some default settings and settings is a
small price to pay for a set of text files that may save your database
from total loss #AND# seem to remove the database bloat as well.
I was wondering if someone knew how to preserve the relationships
as text files so they wouldn''t have to be rebuilt from scratch after
importing tables.
推荐答案
一种替代方案，这是一种迂回方法，将是
为DAO Relation对象的属性创建一个表，然后通过Relations集合中的每个Relation循环
，将属性保存为
a记录在表中。然后，您可以将表格导出为任何其他
表格。重新导入此表后，您可以使用此表使用CreateRelation方法重新创建每个关系
。如果你注意到，Relation对象的
属性和CreateRelation
方法的参数匹配。
我还没有测试了这种方法。我只是提供一种方法
你可能要考虑。
-
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
此响应按原样提供。没有任何陈述或保证。
" MLH" < CR ** @ NorthState.net>在消息中写道
新闻：lc ******************************** @ 4ax.com ......
GHudson的工作程序发布在
http://www.access-programmers.co.uk/...ad.php?t=66320
他们的工作。但是，关系和一些次要的默认设置是不保留的。
。重新建立一些默认设置和设置是一个很小的价格来支付一组文本文件可以保存您的数据库
从总损失＃AND＃似乎删除数据库同样膨胀。
我想知道是否有人知道如何保持关系
作为文本文件，所以他们不必从头开始重建
导入表格之后。
One alternative, and this is something of a roundabout method, would be to
create a table for the properties of the DAO Relation object, and then loop
through each Relation in the Relations collection, saving the properties as
a record in the table. You could then export the table to text as any other
table. Upon re-importing this table, you could use this table to recreate
each relation using the CreateRelation method. If you notice, the
properties of the Relation object and parameters of the CreateRelation
method match up.
I have not tested this approach. I am merely offering it up as one approach
you may want to consider.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"MLH" <CR**@NorthState.net> wrote in message
news:lc********************************@4ax.com...
GHudson has working procedures posted at
http://www.access-programmers.co.uk/...ad.php?t=66320
They work. Relationships, however, and some minor default settings are
not preserved. Reestablishing some default settings and settings is a
small price to pay for a set of text files that may save your database
from total loss #AND# seem to remove the database bloat as well.
I was wondering if someone knew how to preserve the relationships
as text files so they wouldn''t have to be rebuilt from scratch after
importing tables.
这绝对是我没想过的。其他人在这个
NG评论说他们希望从文本中看到100％
的数据库构建。有人建议，这样的
将成为一个出色的Microsoft Access加载项。
这么多，我知道 - 也就是说，我会如果它是可用的，那么就付出代价。肯定的。
Its definitely something I had not thought of. Others in this
NG have commented that they would like to see a 100%
database build from text. It has been suggested that such
would make for an excellent Add-In for Microsoft Access.
This much, I know - and that is, I would pay for it if it were
available. For certain.
您是否尝试导出MSysRelationships表并导入它
来恢复关系？我不知道它是否会起作用，或者它是否会让你b $ b，但值得一试。打开视图|选项中的系统对象
查看系统表。
Have you tried exporting the MSysRelationships table and importing it
to restore the relationships? I have no idea if it will work or if it
will let you, but worth a try. Turn on View | System Objects in Options
to see the system tables.
这篇关于关于将数据库对象保存为文本文件并导入它们...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
