/从.bat文件修复 - 访问97 [英] /repair from a .bat file - access 97

问题描述

我从.bat文件运行此命令。


" C：\ pathToAccess \ MSACCESS.EXE" " C：\pathToDatabase\db.mdb" / REPAIR


按预期进行数据库修复，然后显示消息：


成功修复了......你必须点击确定摆脱

的消息，以便数据库可以关闭。


如何抑制此消息，以便数据库关闭

自动？


我认为这个开关应该修复，然后在没有用户干预的情况下关闭

数据库。

非常感谢任何帮助！提前致谢！

解决方案

有点有趣和有趣的是，所有的搜索都是我已经b / b完成这个特定问题的$ b总是相同的情况。


从来没有答案。人们更常回答你为什么要这样做？b $ b你想要这样做，这很有趣。


如果不能将SUPRESS提供信息

运行命令行/ repair后弹出消息用Access 97切换，为什么不只是

说明了什么？


更有趣的是/ repair来自cli被描述为

Microsoft作为一个命令，应该在完成后自动关闭访问

。


我不喜欢不关心/修复之间的哲学战争。并且

" / compact"或者所述命令的历史发展。


我只是想知道是否有办法强制/修复切换到

函数，因为文档说明它应该。


这就是全部。谢谢！

ri*****@gmail.com 写道：

我正在从.bat文件运行此命令。

C：\ pathToAccess \ MSACCESS.EXE" " C：\pathToDatabase\db.mdb" / REPAIR

数据库按预期修复，然后显示消息：

成功修复了......你必须点击确定摆脱消息，以便数据库可以关闭。

如何抑制此消息，以便数据库自动关闭？

非常感谢任何帮助！提前致谢！

2006年6月25日01:00:49 -0700，ri ***** @ gmail。 COM" < ri ***** @ gmail.com>

写道：


这确实很烦人。这是一个适合我的工作。注意

在JetComp（和更高版本的Access）中没有区别

修复和紧凑。

rem不理想，因为' 'success''messagebox" c：\ program

files \ microsoft office97 \ office \ msaccess.exe" c：\ program

files \ microsoft office97 \office \samples \ northwind.mdb" / repair

rem接下来需要安装JetComp来自
http://support.microsoft.com/?kbid=295334

" c：\ program Files \ microsoft office2000 \ jetcomp.exe" -src：" c：\ program

files \ microsoft office97 \office\samples \ northwind.mdb"

-dest：" c： \ program files \ microsoft

office97 \ office \samples \ northwind2.mdb"

rem Todo：删除旧文件，然后重命名新文件。


-Tom。

我从.bat文件运行此命令。

C： \pathToAccess\MSACCESS.EXE" " C：\pathToDatabase\db.mdb" / REPAIR

数据库按预期修复，然后显示消息：

成功修复了......你必须点击确定摆脱消息，以便数据库可以关闭。

如何抑制此消息，以便数据库自动关闭？

非常感谢任何帮助！在此先感谢！

这是一个多么简单的解决方案！


偶然的机会在那里

jetcomp.exe的语法/开关/选项的完整列表？


将它放入批处理文件中我可以用AT调用。 />

Tom van Stiphout写道：

2006年6月25日01:00:49 -0700，ri ***** @ gmail.com < ri ***** @ gmail.com>
写道：

这确实很烦人。这是一个适合我的工作。注意
在JetComp（及更高版本的Access）中，修复和紧凑之间没有区别。
rem由于'成功''消息框而不理想c：\ program
files\microsoft office97 \ office \ msaccess.exe" c：\ program
files \ microsoft office97 \office \samples \ northwind.mdb" / repair
rem接下来需要安装JetComp来自
http： //support.microsoft.com/?kbid=295334
" c：\ program Files \ microsoft office2000 \ jetcomp.exe" -src：" c：\program
files \ microsoft office97 \office \samples \ northwind.mdb"
-dest：" c：\program files \ microsoft <办公室97.在办公室里：删除旧文件，重新命名新文件。

-Tom。
< blockquote class =post_quotes>我从.bat文件运行此命令。

" C：\ pathToAccess \ MSACCESS.EXE" " C：\pathToDatabase\db.mdb" / REPAIR

数据库按预期修复，然后显示消息：

成功修复了......你必须点击确定摆脱消息，以便数据库可以关闭。

如何抑制此消息，以便数据库自动关闭？

非常感谢任何帮助！提前致谢！

I am running this command from a .bat file.

"C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR

Database repairs as expected, then shows the messge:

"Successfully repaired the ..." and you have to click "Ok" to get rid
of the message so that the database can close.

How does one suppress this message, so that the database shuts down
automatically?

I thought this switch was supposed to repair, then shutdown the
database without user intervention.

Any help is greatly appreciated! Thanks in advance!

解决方案

Somewhat interestingly and funny, is that all the searching that I''ve
done about this specific question always amounted to the same scenario.

There was never an answer. People more commonly replied with a "why do
you want to do that anyway", which is hilarious.

If it is impossible to SUPRESS the informative pop-up message after
running a command-line "/repair" switch with Access 97, why not just
state that?

Even more funny is that "/repair" from the cli is described by
Microsoft as a command that is supposed to automatically close access
after completion.

I don''t care about the philosophical war between "/repair" and
"/compact", or the historical developments of said commands.

I simply want to know if there is a way to FORCE the /repair switch to
function as the documentation states it should.

That''s all. Thanks!

ri*****@gmail.com wrote:

I am running this command from a .bat file.

"C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR

Database repairs as expected, then shows the messge:

"Successfully repaired the ..." and you have to click "Ok" to get rid
of the message so that the database can close.

How does one suppress this message, so that the database shuts down
automatically?

I thought this switch was supposed to repair, then shutdown the
database without user intervention.

Any help is greatly appreciated! Thanks in advance!

On 25 Jun 2006 01:00:49 -0700, "ri*****@gmail.com" <ri*****@gmail.com>
wrote:

That''s indeed annoying. Here is a work around that worked for me. Note
that in JetComp (and later versions of Access) there is no distinction
between repair and compact.
rem Not ideal because of ''success'' messagebox "c:\program
files\microsoft office97\office\msaccess.exe" "c:\program
files\microsoft office97\office\samples\northwind.mdb" /repair
rem Next requires installation of JetComp from
http://support.microsoft.com/?kbid=295334
"c:\program files\microsoft office2000\jetcomp.exe" -src:"c:\program
files\microsoft office97\office\samples\northwind.mdb"
-dest:"c:\program files\microsoft
office97\office\samples\northwind2.mdb"
rem Todo: Delete the old file, and rename the new one.

-Tom.

I am running this command from a .bat file.

"C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR

Database repairs as expected, then shows the messge:

"Successfully repaired the ..." and you have to click "Ok" to get rid
of the message so that the database can close.

How does one suppress this message, so that the database shuts down
automatically?

I thought this switch was supposed to repair, then shutdown the
database without user intervention.

Any help is greatly appreciated! Thanks in advance!

What a great and simple solution!

By chance is there a full list of syntax/switches/options for
jetcomp.exe?

Going to put this into a batch file I can invoke with AT.

Tom van Stiphout wrote:

On 25 Jun 2006 01:00:49 -0700, "ri*****@gmail.com" <ri*****@gmail.com>
wrote:

That''s indeed annoying. Here is a work around that worked for me. Note
that in JetComp (and later versions of Access) there is no distinction
between repair and compact.
rem Not ideal because of ''success'' messagebox "c:\program
files\microsoft office97\office\msaccess.exe" "c:\program
files\microsoft office97\office\samples\northwind.mdb" /repair
rem Next requires installation of JetComp from
http://support.microsoft.com/?kbid=295334
"c:\program files\microsoft office2000\jetcomp.exe" -src:"c:\program
files\microsoft office97\office\samples\northwind.mdb"
-dest:"c:\program files\microsoft
office97\office\samples\northwind2.mdb"
rem Todo: Delete the old file, and rename the new one.

-Tom.

I am running this command from a .bat file.

"C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR

Database repairs as expected, then shows the messge:

"Successfully repaired the ..." and you have to click "Ok" to get rid
of the message so that the database can close.

How does one suppress this message, so that the database shuts down
automatically?

I thought this switch was supposed to repair, then shutdown the
database without user intervention.

Any help is greatly appreciated! Thanks in advance!

这篇关于/从.bat文件修复 - 访问97的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！