巨大的MDB，其中很少 [英] huge MDB with very little in it
问题描述
我有一个MDB（Access 2000格式，使用Access 2003来创建和运行
），即使有
0桌子，
3次传递查询
2小表格
2小报告
5个大约10K的模块
数据库是一个不可收缩的20MB。显然，紧凑和维修
没有帮助，或者我不会在这里。我能想象的是Access
缓存传递查询中的一些数据？ （它们是
，但每个只能返回几行，所以我不确定为什么
会是这样。）
关于如何缩小这个东西的任何想法？ （我正在通过
电子邮件部署，所以20 MB有点多，我不想做用户
拉链周围的教育如果可能的话。）
谢谢。
g。
I''ve got an MDB (Access 2000 format, using Access 2003 to create and
run) that''s just enormous, even though there are"
0 tables,
3 pass-through queries
2 small forms
2 small reports
5 modules of about 10K
The database is an unshrinkable 20MB. Obviously, compact and repair
isn''t helping or I wouldn''t be here. All I can imagine is that Access
caches some of the data from the pass-through queries? (They are
designed to return just a few rows each, though, so I''m not sure why
that would be.)
Any ideas as to how to shrink this thing down? (I''m deploying via
e-mail, so 20 MB is a bit much, and I''d prefer not to have to do user
education around zips and such if possible.)
Thanks.
g.
推荐答案
>我有一个MDB（Access 2000格式，使用Access 2003来创建和
> I''ve got an MDB (Access 2000 format, using Access 2003 to create and
运行），这只是巨大的，即使有
0表，3个传递查询
2个小表格
2个小报告
5个模块大约10K
数据库是一个不可收缩的20MB。显然，紧凑和维修
没有帮助，或者我不会在这里。我能想象的是，Access是否会从传递查询中缓存一些数据？ （它们被设计为每个只返回几行，所以我不确定为什么会这样。）
关于如何收缩的任何想法这东西下来了吗？ （我正在通过
电子邮件进行部署，所以20 MB有点多，而且如果可能的话，我不想在拉链周围进行用户的教育。）
run) that''s just enormous, even though there are"
0 tables,
3 pass-through queries
2 small forms
2 small reports
5 modules of about 10K
The database is an unshrinkable 20MB. Obviously, compact and repair
isn''t helping or I wouldn''t be here. All I can imagine is that Access
caches some of the data from the pass-through queries? (They are
designed to return just a few rows each, though, so I''m not sure why
that would be.)
Any ideas as to how to shrink this thing down? (I''m deploying via
e-mail, so 20 MB is a bit much, and I''d prefer not to have to do user
education around zips and such if possible.)
您可以尝试创建一个新的空数据库，然后从旧数据库导入所有对象。
-
PBsoft di Gabriele Bertolucci
www.pbsoft .it
skype：pbsoftsolution
You may try to create a new empty database and then import all objects from
the old database.
--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
在
新闻：11 ****** ****************@j33g2000cwa.googlegr oups.com，
Graham Charles输入：
In
news:11**********************@j33g2000cwa.googlegr oups.com,
Graham Charles typed:
我有一个MDB（Access 2000格式，使用Access 2003来创建和运行），这只是巨大的，即使有
0表，
3传递查询
2个小表格
2个小报告
5个模块大约10K
这个数据库是一个不可收缩的20MB。显然，紧凑的修复并没有帮助，或者我不会在这里。我只能想象
是否会从
传递查询中缓存一些数据？ （它们的设计只能返回几行
，但是，我不知道为什么会这样。）
关于如何收缩的任何想法这东西下来了吗？ （我是通过电子邮件部署
，所以20 MB有点多，我不想在拉链周围进行用户教育如果可能的话。）
谢谢。
g。
I''ve got an MDB (Access 2000 format, using Access 2003 to
create and run) that''s just enormous, even though there
are"
0 tables,
3 pass-through queries
2 small forms
2 small reports
5 modules of about 10K
The database is an unshrinkable 20MB. Obviously, compact
and
repair isn''t helping or I wouldn''t be here. All I can
imagine
is that Access caches some of the data from the
pass-through
queries? (They are designed to return just a few rows
each,
though, so I''m not sure why that would be.)
Any ideas as to how to shrink this thing down? (I''m
deploying
via e-mail, so 20 MB is a bit much, and I''d prefer not to
have
to do user education around zips and such if possible.)
Thanks.
g.
很久以前有过类似的问题 - 我只能从内存中建议一些
的东西供您调查，并且需要实验。
导入所有对象进入一个新的应用程序mdb - （这对我来说是一次工作
）。
从MSFT站点获取Jet 4的Jetcomp.exe并试用它。
尝试一个\ decompile然后重新编译 - 我怀疑这会使
有任何区别，但必须值得一试。
参考文献：
关于反编译的Tony Toews页面
http ：//www.granite.ab.ca/access/decompile.htm
MVPS
http://www.mvps.org/access/bugs/bugs0008.htm
Michka
http://www.trigeminal.com/usenet/usenet004.asp
-
Nick Coe（英国）
http://www.alphacos.co.uk/
AccHelp现在免费/捐赠用品
Had a similar problem a long time ago - I can only suggest a
couple of things from memory for you to investigate and
experiment with.
Import all objects into a new application mdb - (this worked
for me once).
Get Jetcomp.exe for Jet 4 from the MSFT site and try it.
Try a \decompile and then recompile - I doubt this will make
any difference but must be worth a try.
References:
Tony Toews page on decompile
http://www.granite.ab.ca/access/decompile.htm
MVPS
http://www.mvps.org/access/bugs/bugs0008.htm
Michka
http://www.trigeminal.com/usenet/usenet004.asp
--
Nick Coe (UK)
http://www.alphacos.co.uk/
AccHelp is now free/donateware
非常感谢你们两位;两种方法都没有成功。通过
实验，我发现我的两个小的每一个都是报告占用8MB
左右。它绘制的传递查询具有非常宽的行
（大约200个左右的文本数据列），所以我坚持使用我的
缓存理论。
欢呼，
g。
Thanks much to both of you; neither method was successful. Through
experimenting, I found that each of my two "small" reports takes up 8MB
or so. The pass-through query it draws from has extremely wide rows
(200 or so columns of mostly text data), so I''m sticking with my
caching theory.
Cheers,
g.
这篇关于巨大的MDB，其中很少的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
