本文介绍了如何压缩拆分数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 当您经常添加和删除记录 时,会注意到对数据库进行膨胀的访问。我一直把我的设置紧凑,这很有效。 很棒。现在根据大家的建议,我拆分了我的数据库,所以数据在 的第二个(后端)数据库中,并且链接了所有表。但是,现在当我关闭数据库时,它会压缩前端,因为那是'开放的, 和后端增长。 我现在必须单独手动打开和关闭后端只需要 压缩它。 当然有更好的方法吗? 谢谢, 拉里LAccess is noted for bloating a database when you add and delete recordsfrequently. I have always had mine set to compact on close, and that worksgreat. Now after everyone''s advice I split my database, so the data is ina second (back-end) database with all the tables linked. However, now whenI close the database, it compacts the front end, since that''s what''s open,and the back-end grows.I now have to manually open and close the back-end seperately just tocompact it.Surely there is a better way?Thanks,Larry L推荐答案 嗯,这不仅仅是膨胀。你需要将数据库从时间压缩到到时间来优化表索引,并清理新生的腐败,然后它会出现症状。 是的,有一个拆分的前端数据库,你需要一种定期的方法来压缩数据库,你可以通过使用 $ b $运行Access来实现自动化。 b / compact参数。请参阅启动命令行选项;在访问帮助中获取 详细信息。Well, it''s not just the bloating. You need to compact the database from timeto time to optimize the table indexes, and clean up nascent corruption beforeit presents symptoms.Yes, with a split front-back end database, you need a way to periodicallycompact the database, and you can automate that by running Access with the/compact parameter. See "Startup command-line options" in the Access help fordetails. 压缩数据库来优化表索引,并在出现症状之前清理新生的腐败。 是的,使用拆分的前端数据库,您需要一种定期压缩数据库的方法,并且可以通过使用 / compact参数运行Access来自动执行此操作。请参阅启动命令行选项;在Access中帮助获取详细信息。time to time to optimize the table indexes, and clean up nascent corruptionbefore it presents symptoms. Yes, with a split front-back end database, you need a way to periodically compact the database, and you can automate that by running Access with the /compact parameter. See "Startup command-line options" in the Access helpfor details. 另一个不错的CDMA从前端压缩BE的解决方案: (通知自动换行) http://groups.google.com/groups?hl=p...254024.9.0.131 Robertoanother nice "CDMA" solution to compact BE from te Front End:(notice word wrap) http://groups.google.com/groups?hl=p...254024.9.0.131Roberto 一个非主题观察: 这些Google URL实际上只需要一个参数, selm参数。 所以,这个URL会让你看到同一篇文章: http://groups.google.com/groups?selm...airyahoocom%40 24.9.0.131 获取此URL的最简单方法是以原始的 格式查看文章,并删除& output = gplain参数。 此外,这将以您自己的语言为您提供Google,而您的 网址是特定于语言的。 - David W. Fenton http:// www。 bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassocAn off-topic observation:These Google URLs really only need one argument, the selm argument.So, this URL gets you to the same article: http://groups.google.com/groups?selm...airyahoocom%4024.9.0.131The simplest way to get this URL is to view the article in originalformat and remove the &output=gplain argument.Also, this will get you Google in your own language, whereas yourURL was language-specific.--David W. Fenton http://www.bway.net/~dfentondfenton at bway dot net http://www.bway.net/~dfassoc 这篇关于如何压缩拆分数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-28 07:20