多用户访问MDE文件越来越多....... [英] Multi-User Access MDE File Growing and Growing.......
问题描述
我有一个MDE文件呈指数级增长（从3,900 KB到超过
132,000 KB今天）。我没有在这个MDE中保存数据，尽管我使用了一个用于Read Only查询的离线和SQL表混合。我还有很多
表格和一些报告和查询。许多人每天使用这个数据库，并且每隔几分钟就会有人使用这个数据库。
数据库每隔几周就会崩溃。我想知道这可能是造成崩溃的原因还是仅仅是多用户
环境方面的原因。
我有什么方法可以说紧凑吗？数据库没有
所有用户退出或被踢出数据库（在IS部门通过
我们）？我们必须每两周用一个压缩的
MDE替换数据库。
谢谢。
检查两件事。首先是数据库分为前端和后端
结束服务器上的后端和每个
站的前端副本。这听起来像数据库是一个文件，并且所有用户都是通过网络运行它的
。这将为您提供您描述的问题。
其次，查看数据库中的编程。记录是否经常被添加到临时表中，然后被删除。这是一个肯定的原因
膨胀。
BTW，如果您需要外部帮助您的数据库应用程序，请
请通过以下电子邮件地址与我联系。
-
PC数据表
您的资源获取Access，Excel和Word的帮助应用程序
re******@pcdatasheet.com
www.pcdatasheet.com
" Sonic" < JS ******* @ stateindustrial.com>在消息中写道
news：11 ********************** @ z14g2000cwz.googlegr oups.com ...我有一个MDE文件呈指数级增长（从3,900 KB增加到超过132,000 KB今天）。我没有在这个MDE中保存数据，尽管我使用混合的离线和SQL表进行只读查询。我还有很多
表格和一些报告和查询。很多人每天都会使用这个数据库，并且几乎每分钟都会有人使用这个数据库。
数据库每隔几周就会崩溃。我想知道这个的大小是否可能是导致崩溃的原因还是仅仅是多用户环境方面的问题。
我有什么方法可以解决这个问题。如何紧凑数据库没有让所有用户退出或被踢出DB（我们在IS部门）？我们必须每两周用一个压缩的MDE替换数据库。
谢谢。
不幸的是数据库只有当一个用户在
时它才能被压缩，就我所见，无论如何。
我还没有看到多个用户问题但是尺寸会导致减速并且最终人们厌倦了等待并继续打击
因为他们认为它不起作用而进入，这可能会导致您的崩溃或
它的内存耗尽。
我发现尺寸爆炸交叉
版本用户，即2000，XP和2003使用相同的数据库加剧了问题。如果您有b / b $ b b，请尝试为这些用户制作版本，
表只是链接，因此数据将全部转储到同一位置。 />
我还被告知在使用后我的vb代码中清空并关闭记录集。
如果你有原始代码，那么自动紧凑的代码会检查对于用户
和打开它的人是唯一的用户。
D ...
顺便说一句，你似乎从来没有得知广告在这个过程中没有完成。
BTW，你不能像其他人一样分享你的知识吗？吗？
Arno R.
" PC数据表" <无**** @ nospam.spam> schreef in bericht
新闻：lA ***************** @ newsread2.news.atl.earthl ink.net ...
顺便说一下，如果您需要外部帮助处理数据库应用程序，请通过以下电子邮件地址与我联系。
-
PC数据表
I have an MDE file that is growing exponentially (from 3,900 KB to over
132,000 KB today). I am not saving data in this MDE, although I use a
mix of offline and SQL tables for Read Only querying. I also have many
forms and some reports and queries. Many people use this DB on a daily
basis and there is constantly someone in it, virtually every minute.
The DB tends to crash every couple of weeks. I am wondering if the
size of this could be the cause of the crashes or just the multi-user
environment aspect of this.
Is there any way that I can some how "compact" the DB without having
all of the users either logging out or being kicked out of the DB (by
us in the IS department)? We have to replace the DB with a compacted
MDE about every 2 weeks.
Thanks.
Check two things. First is the database split into a front end and a back
end with the backend on the server and a copy of the front end on each
station. It sounds like the database is one file and all the users are
running it over the network. This will give you the problems you describe.
Second, look at the programming in the database. Are records being
constantly added to temp tables and then later deleted. This is a sure cause
of bloating.
BTW, if you ever need outside help with your database applications, please
contact me at my email address below.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Sonic" <js*******@stateindustrial.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...I have an MDE file that is growing exponentially (from 3,900 KB to over
132,000 KB today). I am not saving data in this MDE, although I use a
mix of offline and SQL tables for Read Only querying. I also have many
forms and some reports and queries. Many people use this DB on a daily
basis and there is constantly someone in it, virtually every minute.
The DB tends to crash every couple of weeks. I am wondering if the
size of this could be the cause of the crashes or just the multi-user
environment aspect of this.
Is there any way that I can some how "compact" the DB without having
all of the users either logging out or being kicked out of the DB (by
us in the IS department)? We have to replace the DB with a compacted
MDE about every 2 weeks.
Thanks.
Unfortunately databases can only be compacted when a single user is in
it, well as far as I have seen anyway.
I have not yet seen multiple users as a problem but size will cause
slow downs and eventually people get tired of waiting and keep hitting
enter because they think it''s not working, this can cause your crash or
it simply runs out of memory.
I found that the "size blow up" problem was exacerbated by cross
version users, ie 2000, XP and 2003 using the same database. If you
have any of that going on try making versions for these users, the
tables are just links so the data will all be dumped in the same spot.
I was also told to empty and close recordsets in my vb code after use.
If you have the original, code in an autocompact which checks for users
and compacts when the person who opens it is the only user.
D...
BTW, you never seem to learn that advertising is ''not done'' in this ng.
BTW, can''t you just share your knowledge just like others do?
Arno R.
"PC Datasheet" <no****@nospam.spam> schreef in bericht
news:lA*****************@newsread2.news.atl.earthl ink.net...
BTW, if you ever need outside help with your database applications, please
contact me at my email address below.
--
PC Datasheet
这篇关于多用户访问MDE文件越来越多.......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
