我希望从头开始重建所有A97桌子 - 哇！喜欢自动化任务。 [英] I wish to rebuild all A97 tables from scratch - whew! Prefer to automate task.
问题描述
在之前的一篇名为
的帖子中，每当我打开特定报告时，A97都会关闭
它有有人建议我重建有问题的表 - 其中一个是b / b
发生了一些腐败。我不知道哪个表是问题，
所以我想在新的数据库中重建它们。我敢肯定，大多数人都会因为想要手动执行此操作而感到畏缩。
大多数应用程序。
所以，我正在写信，问你是否有人编写代码来打印从代码中构建自己的表所需的重要元素。
如果你知道我的意思，那就是让这个过程自动化的东西。手动
建一张桌子并不是什么大问题。但其中有51个？这是另一个
的故事。
这么多个别的领域属性要跟上！哇，有很多
的监督空间和彻头彻尾的错误。想为我能解析的每个表创建一个
的STUFF列表。导入代码
允许我自动重新创建表格 - 在VBA类内部
模块。
我是害怕只是导出任何现有的表格（仅限结构）
害怕未知 - 我根本不知道是否有任何腐败可能存在于任何我现有的表格将被转移到
创建的副本。
In an earlier post entitled...
"A97 closes down each time I open a particular report"
it has been suggested that I rebuild problematic table - one in which
some corruption has occurred. I don''t know which table is the problem,
so I would like to rebuild them all in a new database. I''m sure most
of you would cringe at the thought of having to do this manually for
most of your applications.
So, I''m writing to ask if any of you have written code to print the
vital elements required to construct your own tables from within code.
Something to automate the process, if you know what I mean. Manually
building a table isn''t such a big deal. But 51 of them? That''s another
story altogether.
So many individual field properties to keep up with! Wow, there''s lots
of room for oversights and outright mistakes. Would like to create a
list of STUFF for each table that I could parse & import into code to
allow me to recreate the tables automatically - inside a VBA class
module.
I''m afraid of simply EXPORTING any existing table (structure only) for
fear of the unknown - I simply don''t know whether any corruption that
might be present in any of my existing tables would be transferred to
the copies created.
推荐答案
MLH写道：
MLH wrote:
在之前的一篇名为
的帖子中，每当我打开一份特定报告时A97都会关闭
有人建议我重建有问题的报道表 - 其中发生了一些腐败。我不知道哪个表是问题，
所以我想在一个新的数据库中重建它们。我相信你们中的大多数人都会因为想要为你们的大部分应用程序手动完成而感到畏缩。
所以，我正在写信问如果您有任何人编写代码来打印从代码中构建自己的表所需的重要元素。
如果你知道我的意思，那么自动化过程的东西。手动建立一张桌子并不是什么大问题。但其中有51个？这完全是另一个故事。
要跟上这么多个别的场地属性！哇，有很多空间可以进行疏忽和彻底的错误。想为我能解析的每个表创建一个STUFF列表。导入代码以允许我自动重新创建表 - 在VBA类
模块中。
我害怕只是导出任何现有的表（仅限结构）
对未知事物的恐惧 - 我根本不知道在我现有的任何表格中是否存在任何腐败现象都会转移到创建的副本中。
In an earlier post entitled...
"A97 closes down each time I open a particular report"
it has been suggested that I rebuild problematic table - one in which
some corruption has occurred. I don''t know which table is the problem,
so I would like to rebuild them all in a new database. I''m sure most
of you would cringe at the thought of having to do this manually for
most of your applications.
So, I''m writing to ask if any of you have written code to print the
vital elements required to construct your own tables from within code.
Something to automate the process, if you know what I mean. Manually
building a table isn''t such a big deal. But 51 of them? That''s another
story altogether.
So many individual field properties to keep up with! Wow, there''s lots
of room for oversights and outright mistakes. Would like to create a
list of STUFF for each table that I could parse & import into code to
allow me to recreate the tables automatically - inside a VBA class
module.
I''m afraid of simply EXPORTING any existing table (structure only) for
fear of the unknown - I simply don''t know whether any corruption that
might be present in any of my existing tables would be transferred to
the copies created.
不知道。也许将空表转移到新的mdb。如果任何键
是Autonumber，请将它们更改为Long ...并记得在更新后将它们更改为
到Autonumber。
然后链接到旧数据库中的表。所有链接表格
将具有与空白表格相同的表格名称...但最后的数字为1
。
然后编写一些代码来扫描所有以1结尾的表并编写
查询代码将它们附加到空白表中。
然后删除所有以1结尾的tabledef。
然后将Longs更改回Autonumber。
Don''t know. Maybe transfer the empty tables to a new mdb. If any keys
are Autonumber, change them to Long...and remember to change them back
to Autonumber after the update.
Then link to the tables in the old database. All of the linked tables
will have the same table name as the blank table...but with the number 1
at the end of it.
Then write some code to scan all the tables that end in 1 and write the
query code to append them into the blank table.
Then delete all tabledefs that end in 1.
Then change the Longs back to Autonumber.
MLH写道：
在之前的一篇名为
的帖子中，A97每次打开特定报告时都会关闭
有人建议我重建了有问题的表 - 其中有一些腐败已经发生。我不知道哪个表是问题，
所以我想在一个新的数据库中重建它们。我相信大多数人都会因为想要手动为大多数应用程序而畏缩。
In an earlier post entitled...
"A97 closes down each time I open a particular report"
it has been suggested that I rebuild problematic table - one in which
some corruption has occurred. I don''t know which table is the problem,
so I would like to rebuild them all in a new database. I''m sure most
of you would cringe at the thought of having to do this manually for
most of your applications.
雪橇锤子接近IMO。
只需将现有文件中的所有表格导入一个新表格。 IME
损坏的表将拒绝导入或将在导入
进程中修复。或者，您可以使用
仅限定义导入所有表格。选项。如果腐败只是*数据*那么你可以
之后重新填充新表格。
-
我不喜欢请查看此邮件附带的电子邮件帐户
。发送给... ...
在Hunter dot com的RBrandt
Sledge hammer approach IMO.
Just import all of the tables from the existing file into a new one. IME
corrupted tables will either refuse to import or will be fixed in the import
process. Alternatively you could import all of the tables using the
"Definition Only" option. If the corruption is merely *data* then you can
repopulate the new tables afterwards.
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
我为DBJ撰写了一篇关于使用DDL创建表格的文章。
http://www.databasejournal.com/featu .. .le.php / 3460771
这是很多工作，最后我问是否有人知道一个工具
将Access数据库反向工程为必要的脚本进行重建。
有人提供了这个工具，我玩过它并喜欢...
http://www.synametrics.com/Synametri...rogName=WinSQL
他们提供一个名为WinSQL Lite的免费版本，或者你可以购买
专业版。
如果你只是想要记录你的领域，有很多工具免费
代码。我网站上的DataFast实用程序有这样的文档。只需按照我的标记行中的链接
，然后点击下载。寻找DataFast Utility。
-
Danny J. Lesandrini
dl ********* @ hotmail.com
http://amazecreations.com/datafast/
" MLH" < CR ** @ NorthState.net>写了...
I wrote an article for DBJ about using DDL to create tables.
http://www.databasejournal.com/featu...le.php/3460771
That''s a lot of work, and I concluded by asking if anyone knew of a tool that
would reverse engineer an Access database into the requisite scripts to rebuild.
Someone provided this tool, which I played with and liked ...
http://www.synametrics.com/Synametri...rogName=WinSQL
They provide a free version called WinSQL Lite or you can purchase the
professional version.
If you just want to document your fields, there are lots of tools and free
code. The DataFast Utility at my site has such a documentor. Just follow
the link in my tag line and click on Downloads. Look for DataFast Utility.
--
Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/
"MLH" <CR**@NorthState.net> wrote ...
在之前的一篇名为
的帖子中，每当我打开一份特定报告时A97都会关闭
它有人建议我重建有问题的表 - 其中有一些腐败已经发生。我不知道哪个表是问题，
所以我想在一个新的数据库中重建它们。我相信你们中的大多数人都会因为想要为你们的大部分应用程序手动完成而感到畏缩。
所以，我正在写信问如果您有任何人编写代码来打印从代码中构建自己的表所需的重要元素。
如果你知道我的意思，那么自动化过程的东西。手动建立一张桌子并不是什么大问题。但其中有51个？这完全是另一个故事。
要跟上这么多个别的场地属性！哇，有很多空间可以进行疏忽和彻底的错误。想为我能解析的每个表创建一个STUFF列表。导入代码以允许我自动重新创建表 - 在VBA类
模块中。
我害怕只是导出任何现有的表（仅限结构）
对未知事物的恐惧 - 我根本不知道在我现有的任何表格中是否存在任何腐败现象都会转移到创建的副本中。
In an earlier post entitled...
"A97 closes down each time I open a particular report"
it has been suggested that I rebuild problematic table - one in which
some corruption has occurred. I don''t know which table is the problem,
so I would like to rebuild them all in a new database. I''m sure most
of you would cringe at the thought of having to do this manually for
most of your applications.
So, I''m writing to ask if any of you have written code to print the
vital elements required to construct your own tables from within code.
Something to automate the process, if you know what I mean. Manually
building a table isn''t such a big deal. But 51 of them? That''s another
story altogether.
So many individual field properties to keep up with! Wow, there''s lots
of room for oversights and outright mistakes. Would like to create a
list of STUFF for each table that I could parse & import into code to
allow me to recreate the tables automatically - inside a VBA class
module.
I''m afraid of simply EXPORTING any existing table (structure only) for
fear of the unknown - I simply don''t know whether any corruption that
might be present in any of my existing tables would be transferred to
the copies created.
这篇关于我希望从头开始重建所有A97桌子 - 哇！喜欢自动化任务。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
