与数据库相比，网络性能超过10Mb [英] Bad network performance over 10Mb line with database
问题描述
你好，
新来的。现在已经在这个论坛上搜索了几个小时（我不是kddin）....已经找到了我的问题的解决方案。
我有一个访问数据库。拆分前端和后端。两者都位于服务器上。
用户通过桌面上的快捷方式访问它
原始数据库创建于97 ....升级和修改版本2K，现在在2003年升级，修改和运行。
数据库正在我国家（挪威）的服务器上运行。用户使用它没有问题。多用户登录大约5 ...没有probs。
如果我将数据库复制到我们公司的另一台服务器（位于Danmark）同样的故事，一切正常。
但是，如果我尝试从挪威（超过10Mbit线路）访问丹麦服务器上的数据库，那么它非常慢。 2分钟打开表格。
我试过制作一个MDE文件。获取错误消息他们表存在问题，并且它会在索引，主要键或关系中创建重复值。
但它确实创建了一个DB1.mde文件。它不起作用，但文件就在那里。
即使我确实告诉Access以不同的方式调用新文件。
我不知道SQL和说实话，我不认为它会让它变得更好，因为在一台服务器上运行正常，它只是10Mb线似乎是问题。
IT人员告诉我真正的dataload我的数据库的行大约是1Mb，所以它不应该是速度问题。
任何人都有这方面的经验吗？
或任何建议如何创建MDE。有没有办法找出我的数据库究竟有什么问题，而不是这个非特定的错误信息。??
thnx。
Erik。
Hello,
New here. Have been searching this forum for a couple of hours now ( i am not kddin).... Havnt been able to find the solution to my problem.
I have a access database. Split front and backend. Both located on a server.
Users access it trough a shortcut on there desktop
The original database was created in 97 .... upgraded and modified in version 2K and now upgraded, modified and running in 2003.
The database is running on a server standing in my country (norway). Users have no problem using it. Multiple user login about 5 ... no probs.
If i copy the database to another server of our company (located in Danmark) the same story, everything works fine.
BUT if i try to access the database standing on the Danish server from Norway (over a 10Mbit line) it is VERY slow. 2 minutes to open the a form.
I have tried making a MDE file. Get an error message that there is a problem with ''they table'' and that it would create duplicate values in the index, primairy key or relationships.
But it does create a DB1.mde file anyway. It does not work, but the file is there.
Even though i did tell Access to call the new file differently.
I dont know SQL and to be honest i dont think it would make it better since on one server it runs fine, it is just the 10Mb line that seems to be the problem.
The IT guys told me that the real dataload on that line for my database was about 1Mb max, so it should not be a speed issue.
Any one have any experience with this?
Or any suggestions what to do with the creation of the MDE. Is there a way to find out What exactly is wrong with my database instead of this non specific error message.??
thnx.
Erik.
推荐答案
您好Erik
首先打开数据库并尝试从VBA编辑器编译它。看看将它转换为2003年是否存在任何冲突或不兼容。
让我知道你发现了什么。
Mary
Hi Erik
First open the Database and try to compile it from the VBA editor. See if there are any conflicts or incompatibilities left over from converting it up to 2003.
Let me know what you find.
Mary
我试过编译数据库。
我工作正常...我没有收到任何消息。直到我尝试关闭数据库。
它问我是否要保存更改到我以前进入VBeditor的表单。
如果我说是的话，我得到他们表有问题的消息，并且它会在索引，主要键或关系中创建重复值
如果我按住转义按钮，我会得到一些负载直到最后我才退出该计划。之后我因为VB腐败而无法再次启动它。
我的前端不再工作.....（ofcours我做了备份:-)
有什么建议吗？除了重新开始之外可能吗？
thnx。
I have tried compiling the database.
I works fine... i get no messages. Untill i try to close the database.
it asks me if i want to save changes to the form i used to get in the VBeditor.
if i say yes, i get the message that there is a problem with ''they table'' and that it would create duplicate values in the index, primairy key or relationships
If i hold the escape button i get a load of those untill finally i am out of the program. After that i cannot start it again beacause of a VB corruption.
My front end doesnt work anymore..... (ofcours i made a backup :-)
Any suggestions ?, apart from starting over again maybe ?
thnx.
表格绑定的记录集是什么？
表单背后的代码是什么？
打开此表单时会自动创建记录吗？
What recordset is the form bound to?
What is the code behind the form?
When you open this form does a record automatically get created?
这篇关于与数据库相比，网络性能超过10Mb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
