紧凑型/紧凑型 [英] Compact/Compact on Close

问题描述

我在A2K中有许多数据库，在不同的机器上编写，并且不同的安装了
。我发现压缩数据库

在它打开时经常会失败，看似随意。这通常很烦人，因为我通常在工具/选项中设置Compact on Close设置为

true。


有没有人否则经历过这个并且有解决方法吗？感谢您的帮助，


Jim F.

Hi,

I have a number of databases in A2K, written on different machines with
different installations of Office. I have found that compacting a database
while it is open regularly fails, seemingly at random. This is especially
annoying as I usually set the Compact on Close setting in Tools/Options to
true.

Has anyone else experienced this and is there a fix? Thanks for any help,

Jim F.

推荐答案

为什么要设置Compact-on -close" ;?这是MS发明的最无用的价值。


Compact-on-close什么？它只能压缩FE。


所有敏感软件都使用FE / BE排列，其中主数据在BE数据库中保存为
。因此，它是需要压缩的BE。

（前端/后端）


为什么你会紧凑，大概每天多次，每次

你关闭数据库？压缩需要通常每月做一次或者无论如何都需要。每次压缩时，都会有额外的危险，无论多么轻微，损坏数据库都会造成损害。


正确执行并创建一个单独的快捷方式来压缩数据库，

管理员当每个人都不在时，并且只在必要时。


克里斯


" ;詹姆斯富兰克林 < JA ************ @ ntlworld.com>在消息中写道

news：hb ****************** @ newsfep1-win.server.ntli.net ...

Whyever would you set "Compact-on-close"? This is about the most useless
option MS ever invented.

"Compact-on-close" what? It can only compact the FE.

All sensible software uses an FE/BE arrangement, where the main data is held
in the BE database. Therefore, it''s the BE which needs compacting.
(Front-End/Back-End)

Why would you compact-on-close, presumably multiple times a day, every time
you close the database? Compacting needs doing typically once a month or
whatever. Every time you compact, there is additional danger, however slight,
of corrupting the database.

Do it properly and create a separate shortcut to compact the database, by the
administrator when everyone is out of it, and only as necessary.

Chris

"James Franklin" <ja************@ntlworld.com> wrote in message
news:hb******************@newsfep1-win.server.ntli.net...

我在A2K中有许多数据库，用不同的Office安装在不同的机器上。我发现在数据库打开时压缩数据库会定期失败，看似随意。这通常很烦人，因为我通常将工具/选项中的Compact on Close设置为true。

有没有其他人经历过这个并且有修复吗？感谢您的帮助，

Jim F.

Hi,

I have a number of databases in A2K, written on different machines with
different installations of Office. I have found that compacting a database
while it is open regularly fails, seemingly at random. This is especially
annoying as I usually set the Compact on Close setting in Tools/Options to
true.

Has anyone else experienced this and is there a fix? Thanks for any help,

Jim F.

您好，


感谢Chris的输入。我的所有数据库都是FE / BE，但是每次创建记录集时，FE

就会膨胀。有些文件只是每天打开一次，而且用户不能访问专家，所以似乎合情合理

Compact on Close。 （如果我放了一个快捷方式，它将永远不会被使用......）


此外，它不仅会发生，而且有时也会在压缩时产生

手动，这关心我。我同意也许Compact on Close不是

最佳解决方案，但如果它在那里，它应该至少有效！


Jim F.


" Chris Mills" < pH值********* @ cleardotnet.nz>在消息中写道

新闻：uj ************** @ TK2MSFTNGP12.phx.gbl ...

Hi,

Thanks for the input Chris. All my databases are FE/BE, however the FE
bloats everytime recordsets are created etc. Some of the files are only
opened once a day, and users are not Access experts, so seems logical to
Compact on Close. (If I put a shortcut, it will never get used...)

In addition, it not only happens then, but also sometimes when compacting
manually, which concerns me. I agree that maybe Compact on Close isnt the
best solution, but if it is in there, it should at least work!

Jim F.

"Chris Mills" <ph*********@cleardotnet.nz> wrote in message
news:uj**************@TK2MSFTNGP12.phx.gbl...

为什么你要设置& ;紧凑型上靠近" ;?这是MS发明的最无用的选择。

紧凑型关闭什么？它只能压缩FE。

所有敏感软件都使用FE / BE排列，其中主要数据是BE数据库中保存的
。因此，它是需要压缩的BE。
（前端/后端）

为什么你会紧密关闭，大概每天多次，每个
关闭数据库的时间？压缩需要通常每月做一次或任何事情。每次压缩时，都会有额外的危险，但是会损坏数据库。

正确执行并创建一个单独的快捷方式来压缩数据库，
管理员当每个人都离开它时，并且只在必要时。

Chris

James Franklin < JA ************ @ ntlworld.com>在消息中写道
新闻：hb ****************** @ newsfep1-win.server.ntli.net ...

Whyever would you set "Compact-on-close"? This is about the most useless
option MS ever invented.

"Compact-on-close" what? It can only compact the FE.

All sensible software uses an FE/BE arrangement, where the main data is held in the BE database. Therefore, it''s the BE which needs compacting.
(Front-End/Back-End)

Why would you compact-on-close, presumably multiple times a day, every time you close the database? Compacting needs doing typically once a month or
whatever. Every time you compact, there is additional danger, however slight, of corrupting the database.

Do it properly and create a separate shortcut to compact the database, by the administrator when everyone is out of it, and only as necessary.

Chris

"James Franklin" <ja************@ntlworld.com> wrote in message
news:hb******************@newsfep1-win.server.ntli.net...

你好，

我在A2K中有许多数据库，使用不同的Office安装在不同的机器上编写。我发现压缩
数据库时，它经常会失败，似乎是随机的。这是
特别烦人，因为我通常将Tools / Options
中的Compact on Close设置为true。

有没有其他人经历过这个并且有修复吗？感谢任何
帮助，
Jim F.

Hi,

I have a number of databases in A2K, written on different machines with
different installations of Office. I have found that compacting a database while it is open regularly fails, seemingly at random. This is especially annoying as I usually set the Compact on Close setting in Tools/Options to true.

Has anyone else experienced this and is there a fix? Thanks for any help,
Jim F.

压缩FE>确实<合理。通常，查询将在

FE中。当编译每个查询时，Jet使用来自BE的性能统计数据来确定（并保存）最佳的执行计划。对于FE查询。

此计划存储在FE中，而不是BE中。


压缩BE时，将重新计算性能统计信息。 （那个

是做一个紧凑的好处之一）。但是，在FE / BE情况下，FE中的查询计划是>不是<根据更新的

性能统计数据重新创建，除非&直到> FE<因此，除非/直到FE也被压缩，否则FE查询实际上不会受益于压缩BE中的更新性能

统计数据。


HTH，

TC

" Chris Mills" < pH值********* @ cleardotnet.nz>在消息中写道

新闻：uj ************** @ TK2MSFTNGP12.phx.gbl ...

Compaction of the FE >does< make sense. Normally, the queries will be in the
FE. When each query is compiled, Jet uses performance statistics from the BE
tables do determine (& save) an optimal "execution plan" for the FE query.
This plan is stored in the FE, not the BE.

When the BE is compacted, the performance statistics are recomputed. (That
is one of the benefits of doing a compact). However, in a FE/BE situation,
the query plans in the FE are >not< recreated against the updated
performance statistics, unless & until the >FE< is compacted.

So, FE queries do not actually benefit from the updarted performance
statistics in the compacted BE, unless/until the FE is compacted also.

HTH,
TC
"Chris Mills" <ph*********@cleardotnet.nz> wrote in message
news:uj**************@TK2MSFTNGP12.phx.gbl...

为什么你要设置& ;紧凑型上靠近" ;?这是MS发明的最无用的选择。

紧凑型关闭什么？它只能压缩FE。

所有敏感软件都使用FE / BE排列，其中主要数据是BE数据库中保存的
。因此，它是需要压缩的BE。
（前端/后端）

为什么你会紧密关闭，大概每天多次，每个
关闭数据库的时间？压缩需要通常每月做一次或任何事情。每次压缩时，都会有额外的危险，但是会损坏数据库。

正确执行并创建一个单独的快捷方式来压缩数据库，
管理员当每个人都离开它时，并且只在必要时。

Chris

James Franklin < JA ************ @ ntlworld.com>在消息中写道
新闻：hb ****************** @ newsfep1-win.server.ntli.net ...

Whyever would you set "Compact-on-close"? This is about the most useless
option MS ever invented.

"Compact-on-close" what? It can only compact the FE.

All sensible software uses an FE/BE arrangement, where the main data is held in the BE database. Therefore, it''s the BE which needs compacting.
(Front-End/Back-End)

Why would you compact-on-close, presumably multiple times a day, every time you close the database? Compacting needs doing typically once a month or
whatever. Every time you compact, there is additional danger, however slight, of corrupting the database.

Do it properly and create a separate shortcut to compact the database, by the administrator when everyone is out of it, and only as necessary.

Chris

"James Franklin" <ja************@ntlworld.com> wrote in message
news:hb******************@newsfep1-win.server.ntli.net...

你好，

我在A2K中有许多数据库，使用不同的Office安装在不同的机器上编写。我发现压缩
数据库时，它经常会失败，似乎是随机的。这是
特别烦人，因为我通常将Tools / Options
中的Compact on Close设置为true。

有没有其他人经历过这个并且有修复吗？感谢任何
的帮助，
Jim F.

Hi,

I have a number of databases in A2K, written on different machines with
different installations of Office. I have found that compacting a database while it is open regularly fails, seemingly at random. This is especially annoying as I usually set the Compact on Close setting in Tools/Options to true.

Has anyone else experienced this and is there a fix? Thanks for any help,
Jim F.

这篇关于紧凑型/紧凑型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！