Access 2010 数据库规模呈爆炸式增长
我有一个从 Excel 电子表格创建的 Access 数据库。
该数据库包含一个包含 58 个字段的主表、三个包含大约 10 个字段的其他表以及一个包含两个字段的表。大多数新信息都将进入主表。
使用一天后（两个用户），数据库从 20MB 激增至 50MB。正在添加一些新记录，但不足以生成 30MB。当我完成从 Excel 的导入并压缩数据库后，我的主表有 4000 条记录。
用户添加的新记录不超过几十条，压缩后数据库大小又回落到 20MB 左右。这是2010年的普遍现象吗？ 2000/2003 年从未经历过这种情况。
谢谢， 韦斯特利
I have an Access database that I created from an Excel spreadsheet.
The DB contains a main table with 58 fields, three other tables that have about 10 fields, and a last table with two fields. Most of the new information is going into the main table.
After a days use (two users), the database is exploding from 20MB to 50MB. Some new records are being added, but not enough to generate 30MB. My main table had 4000 records after I finished my import from Excel and compacted the database.
The users have not added more than a few dozen new records and the database drops back down to around 20MB after a compact. Is this something that is common in 2010? Never experienced this with 2000/2003.
Thanks,
Westley
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
是的，这很常见。
大量的插入/删除也会导致增长。
ACC：修改 SQL 语句时数据库会快速增长
感兴趣吗？： MS Access 文件大小不断增大的问题
Yes, it is common.
Lots of insertions/deletes will also cause growth.
ACC: Database Grows Rapidly When You Modify SQL Statements
Of interest?: Growing MS Access File Size problem
报告中的图片也会导致数据库大小增大
我发现了另一种增加 Access 数据库大小的方法。如果您有一个报告（可能还有一个表单？），其中有从外部文件插入的图片，那么“图片类型”选项之一就是“共享”。如果使用此选项，则每次使用不同的图片时，Access 都会存储图片的新本地副本。我的 1MByte Access 数据库最终内部存储了 500MByte 的图片。似乎没有任何方法可以刷新它们，并且压缩数据库不会清除它们。
解决方案是使用“链接”“图片类型”设置。我将数据库内容复制到一个新数据库，它一直保持在 1MByte。
Pictures in reports can also cause the database to grow in size
I have found another way that an access database can increase in size. If you have a report (and possibly also a form?) where there are pictures that are inserted from an external file then one of the "picture type" options is 'shared'. If this option is used then Access stores a new local copy of the picture every time a different picture is used. My 1MByte Access database ended up with 500MByte of internally stored pictures. There does not appear to be any way of flushing them and compacting the database does not clear them.
The solution is to use the 'linked' "picture type" setting. I copied the database contents to a new database, and it has stayed at 1MByte.