.mdb和TCP - 奇怪的问题 [英] .mdb and TCP - weird problem

问题描述

我正在遇到.mdb文件的奇怪问题。

我们有两栋通过光纤连接的建筑物（一个局域网）。 />
一切都适用于任何文件，任何大小，任何应用程序

软件。硬件已经过多次测试。病毒，特洛伊木马

等等：干净肯定。

问题是.mdb文件（_only .mdb files_）经常不打开，

非常慢，甚至崩溃和损坏。

奇怪的是，即使使用操作系统复制它们（使用XP SP2测试，

W2K， Server 2003）也行不通。

使用嗅探器的TCP流量分析揭示了大量错误：

段丢失，重复ACK，重传等不可能

了解发生了什么。

有没有人经历过类似的事情？


Luca

Hi,
I''m experiencing a strange problem with .mdb files.
We have two buildings connected by optical fiber (a single LAN).
Everything works perfect with any file, any size, any application
software. The hardware has been tested several times. Viruses, trojans
and so on: clean for sure.
The problem is that .mdb files (_only .mdb files_) often don''t open,
are very slow, or even get crashed and corrupted.
The weird is that even copying them using the OS (tested with XP SP2,
W2K, Server 2003) also doesn''t work.
TCP traffic analysis using a sniffer reveals a huge mess of errors:
segments lost, duplicate ACKs, retransmission, etc. Impossible to
understand what''s happening.
Did anyone ever experienced something similar?

Luca

推荐答案

on **** ******@iao.florence.it 写道：

on**********@iao.florence.it wrote:

我正在经历一个.mdb文件的奇怪问题。

我们有两栋通过光纤连接的建筑物（一个局域网）。

一切都很完美任何文件，任何大小，任何应用程序

软件。硬件已经过多次测试。病毒，特洛伊木马

等等：干净肯定。

问题是.mdb文件（_only .mdb files_）经常不打开，

非常慢，甚至崩溃和损坏。

奇怪的是，即使使用操作系统复制它们（使用XP SP2测试，

W2K， Server 2003）也行不通。

使用嗅探器的TCP流量分析揭示了大量错误：

段丢失，重复ACK，重传等不可能

了解发生了什么。

有没有人经历过类似的事情？


Luca

Hi,
I''m experiencing a strange problem with .mdb files.
We have two buildings connected by optical fiber (a single LAN).
Everything works perfect with any file, any size, any application
software. The hardware has been tested several times. Viruses, trojans
and so on: clean for sure.
The problem is that .mdb files (_only .mdb files_) often don''t open,
are very slow, or even get crashed and corrupted.
The weird is that even copying them using the OS (tested with XP SP2,
W2K, Server 2003) also doesn''t work.
TCP traffic analysis using a sniffer reveals a huge mess of errors:
segments lost, duplicate ACKs, retransmission, etc. Impossible to
understand what''s happening.
Did anyone ever experienced something similar?

Luca

因为你的mdb可能部分损坏了......

如果每个人都出局，可能暂时修改你的桌面图标

类似

" C：\ MSACCESS.EXE" " YourMDBPath.mdb" / excl

然后压缩它


再次修改并添加反编译开关

" C：\ MSACCESS.EXE" ; " YourMDBPath.mdb" / excl / decompile


反编译后，退出并返回

" C：\ MSACCESS.EXE" " YourMDBPath.mdb" / excl

然后输入并压缩它然后重新编译应用程序。修复任何

编译器错误（如果有的话）。


检查并查看是否有正确的引用。每个人都是最新的

他们的服务包（帮助/关于MS-Access）


您对DAO 3.6的引用和其他人有参考DAO 3.51？

或者也许创建一个新的mdb并导入所有对象（记得要点击

选项导入菜单等）


只需检查一些事项。

Since it''s possible your mdb is partially corrupted...

If everyone is out maybe modify your desktop icon temporarily to
something like
"C:\MSACCESS.EXE" "YourMDBPath.mdb" /excl
and then compact it

Modify again and add the decompile switch
"C:\MSACCESS.EXE" "YourMDBPath.mdb" /excl /decompile

After decompiled, exit out and go back to
"C:\MSACCESS.EXE" "YourMDBPath.mdb" /excl
and enter it and compact it and then recompile the app. Fix any
compiler errors if any.

Check and see if you have proper references. Is everybody up to date on
their service packs (Help/About in MS-Access)

Is your reference to DAO 3.6 and others have a ref to DAO 3.51?

Or perhaps create a new mdb and import all the objects (remember to hit
Options to import menus, etc)

Just some things to check.

8月2日上午11:00，沙拉< o ... @醋.comwrote：

On Aug 2, 11:00 am, Salad <[e-mail]:

ongaro.ad ... @ iao.florence.it写道：

[e-mail] wrote:

我正在遇到.mdb文件的奇怪问题。

我们有两座建筑物通过光纤连接（一个局域网）。

一切都适用于任何文件，任何大小，任何应用程序

软件。硬件已经过多次测试。病毒，特洛伊木马

等等：干净肯定。

问题是.mdb文件（_only .mdb files_）经常不打开，

非常慢，甚至崩溃和损坏。

奇怪的是，即使使用操作系统复制它们（使用XP SP2测试，

W2K， Server 2003）也行不通。

使用嗅探器的TCP流量分析揭示了大量错误：

段丢失，重复ACK，重传等不可能

了解发生了什么。

有没有人经历过类似的事情？

Hi,
I''m experiencing a strange problem with .mdb files.
We have two buildings connected by optical fiber (a single LAN).
Everything works perfect with any file, any size, any application
software. The hardware has been tested several times. Viruses, trojans
and so on: clean for sure.
The problem is that .mdb files (_only .mdb files_) often don''t open,
are very slow, or even get crashed and corrupted.
The weird is that even copying them using the OS (tested with XP SP2,
W2K, Server 2003) also doesn''t work.
TCP traffic analysis using a sniffer reveals a huge mess of errors:
segments lost, duplicate ACKs, retransmission, etc. Impossible to
understand what''s happening.
Did anyone ever experienced something similar?

Luca

Luca

因为你的mdb可能部分损坏了.. 。


如果每个人都出去了，可以暂时修改你的桌面图标

类似

" C：\ MSACCESS。 EXE" " YourMDBPath.mdb" / excl

然后压缩它


再次修改并添加反编译开关

" C：\ MSACCESS.EXE" ; " YourMDBPath.mdb" / excl / decompile


反编译后，退出并返回

" C：\ MSACCESS.EXE" " YourMDBPath.mdb" / excl

然后输入并压缩它然后重新编译应用程序。修复任何

编译器错误（如果有的话）。


检查并查看是否有正确的引用。每个人都是最新的

他们的服务包（帮助/关于MS-Access）


您对DAO 3.6的引用和其他人有参考DAO 3.51？

或者也许创建一个新的mdb并导入所有对象（记得要点击

选项导入菜单等）


只是要检查的一些事情。

Since it''s possible your mdb is partially corrupted...

If everyone is out maybe modify your desktop icon temporarily to
something like
"C:\MSACCESS.EXE" "YourMDBPath.mdb" /excl
and then compact it

Modify again and add the decompile switch
"C:\MSACCESS.EXE" "YourMDBPath.mdb" /excl /decompile

After decompiled, exit out and go back to
"C:\MSACCESS.EXE" "YourMDBPath.mdb" /excl
and enter it and compact it and then recompile the app. Fix any
compiler errors if any.

Check and see if you have proper references. Is everybody up to date on
their service packs (Help/About in MS-Access)

Is your reference to DAO 3.6 and others have a ref to DAO 3.51?

Or perhaps create a new mdb and import all the objects (remember to hit
Options to import menus, etc)

Just some things to check.

谢谢，

但是我们检查了你已经建议的所有内容。问题仍然存在

还有空白的新.mdb文件。

我忘了提到两个中没有任何问题

单局域网段，麻烦就是当穿过光纤时，只有.mdb文件（我们也尝试重命名它们，没有

方式）。

它在我看来更多与文件系统

处理.mdb文件的方式有关。显然，它以与其他文件类型不同的方式进行，使得它们对小的传输延迟非常敏感。


Luca

Thank you,
but we checked all what you suggested already. The problem persists
also with blank empty new .mdb files.
I forgot to mention that no problems occur inside any of the two
single LAN segments, the trouble is just when crossing the optic
fiber, and only with .mdb files (we tried also to rename them, no
way).
It looks to me more something related to the way the filesystem
handles .mdb files. Apparently, it does it in a different way than
other filetypes, making them dramatically sensitive to small
transmission delays.

Luca

< on ********** @ iao.florence.itwrote in message

新闻：11 ********************** @ w3g2000hsg.googlegro ups.com ...

<on**********@iao.florence.itwrote in message
news:11**********************@w3g2000hsg.googlegro ups.com...

我正在遇到.mdb文件的奇怪问题。

我们有两座建筑用光纤连接（一块LAN）。

一切都适用于任何文件，任何大小，任何应用程序

软件。硬件已经过多次测试。病毒，特洛伊木马

等等：干净肯定。

问题是.mdb文件（_only .mdb files_）经常不打开，

非常慢，甚至崩溃和损坏。

奇怪的是，即使使用操作系统复制它们（使用XP SP2测试，

W2K， Server 2003）也行不通。

使用嗅探器的TCP流量分析揭示了大量错误：

段丢失，重复ACK，重传等不可能

了解发生了什么。

有没有人经历过类似的事情？


Luca

Hi,
I''m experiencing a strange problem with .mdb files.
We have two buildings connected by optical fiber (a single LAN).
Everything works perfect with any file, any size, any application
software. The hardware has been tested several times. Viruses, trojans
and so on: clean for sure.
The problem is that .mdb files (_only .mdb files_) often don''t open,
are very slow, or even get crashed and corrupted.
The weird is that even copying them using the OS (tested with XP SP2,
W2K, Server 2003) also doesn''t work.
TCP traffic analysis using a sniffer reveals a huge mess of errors:
segments lost, duplicate ACKs, retransmission, etc. Impossible to
understand what''s happening.
Did anyone ever experienced something similar?

Luca

Access不能在不稳定的网络和你的嗅探器上运行良好

报告混乱的错误。访问文件不会发送到工作站，

它们被打开，信息在服务器和

工作站之间传输。

Access does not function well over unstable networks and your sniffer
reports a "mess of errors". Access files are NOT sent to the workstation,
they are opened and information is transmitted between the server and
workstation.

这篇关于.mdb和TCP - 奇怪的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！