MS Access 无法创建 MDE 错误。对象过多
所以我在工作中有一个 MS Access 数据库。最近，我尝试发布另一个 MDE 文件，该文件实际上从以前存在的报告中删除了一些内容。现在我收到此错误，提示“MS Access 无法创建 MDE”，并带有一个小显示帮助按钮...单击显示帮助按钮，它会给出有关此问题的描述，通常与太多对象（表单、报告、表等）。这个数据库根本不是很大，所以我想知道这是怎么发生的？
每次我一遍又一遍地发布仅进行微小更改、所有相同表格、报告等的 MDE 时，这是否算数？
这是否是另一个错误，并且弹出框是一种笼统的或通用的？
有办法解决这个问题吗？
这是否计算表单/报告上的对象（文本框、CMB 框等）？
基本上，帮助中给出的示例表示，如果您有 500 个表单，每个表单有 2 个模块，那么这将算作 1000....该数据库大约有 12 个表单、4 个查询、16 个表（最大记录 = > ;1000 条记录）并且不是很大。自从上次我毫无问题地发布 MDE 以来，我只尝试从这个新报告的报告中删除一个项目，而没有添加任何新内容。
请帮忙......有人为此尖叫，我束手无策！
谢谢
So I have a MS Access database at work. Recently I tried to put out another MDE file, that actually took something off a report that was previously there. Now I am getting this error that says, "MS Access cannot create the MDE" with a little show help button....click the show help button and it gives a description about this relating typically to too many objects (Forms, reports, tables, etc). This database is not very big at all, so I am wondering how this could be happening?
Does it count each time I release an MDE with only minor changes, all the same forms, reports, etc over and over again?
Could this be another error and the pop up box is kind of blanket or generic?
Is there anyway to solve this?
Does this count objects on a form/report (text boxes, cmb boxes, etc)?
Basically the example given in the help says that if you have 500 forms, and 2 modules for each form, then that would count as a 1000....this database has about 12 forms, 4 queries, 16 tables (max record = >1000 records) and is not very big. Since the last time I released an MDE with no problem, I have only tried to deleate an item off a report for this new one, without adding anything new.
Please help....there are screaming for this, and I am at my wits end!
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
是的，这是一条误导性和笼统的错误消息。尝试编译您的代码。 Ctrl+g>>调试>>编译应该告诉您哪行代码导致了您的问题。
我建议经常编译您的代码。我每隔几行代码就这样做一次。
报告中可能有一些代码引用了您从报告中删除的控件。
Yes, this is a misleaidng and blanket error message. Try compiling your code. Ctrl+g >> Debug >> Compile should tell you what line of codes is/are causing your problem.
I would suggest compiling your code on a frequent basis. I do so every few lines of code.
Chances are you had some code in the report referencing the control you removed from the report.
对象在数据库的生命周期内有效，也就是说，即使删除它们，它们仍然有效。我建议你
反编译，紧凑&修复，然后将所有内容复制到一个新的数据库中，这将为您提供一个漂亮、干净的副本。确保它可以编译，然后创建您的 mde。Objects count for the life of the database, that is, even if you delete them, they still count. I suggest you
decompile, compact & repair, and then copy everything into a fresh database, which will get you a nice, clean copy. Make sure it compiles and then create your mde.