无法编译MS Access2013应用程序 [英] Unable to compile MS Access2013 application
问题描述
     我需要您帮助编译MS Access2013应用程序。
此应用程序的后端数据库是位于azure服务器中的SQL数据库。
这是我的方案：
我每次尝试编译此应用程序时都收到以下错误消息：
"此错误通常与将大型数据库编译为MDE文件有关。 由于用于编译数据库的方法，为每个表创建了大量的TableID引用。 Access数据库引擎一次只能创建
最多2048个打开的TableID。 如果数据库具有大量对象（表，宏，表单，报表等），则将数据库导出为MDE可能会超出此限制。
没有准确的方法来估计数量Access数据库引擎在将数据库编译为MDE的过程中使用的TableID。 但是，每个VBA模块和每个表单使用一个TableID，因此，如果数据库有500个表单，并且
每个表单的HasModule属性设置为Yes，则使用多达1,000个TableID。"
I need your help on compiling our MS Access2013 application.
The back-end database of this application is SQL database located in azure server.
Here is my scenario:
I have received the following error message each time I attempted to compile this application:
"This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create
a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and
each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."
推荐答案
您好，
您提供的信息量不足以找出问题所在。
可能是编译问题（有些错误）？
b
$
也许
https： //support.microsoft.com/en-us/help/283788/access-microsoft-access-was-unable-to-create-an-mde-accde-or-ade-datab 可能有帮助吗？
The amount of info you supplied isn't enough to figure out the problem.
Could it be a compile issue (some error)?
Maybe
https://support.microsoft.com/en-us/help/283788/access-microsoft-access-was-unable-to-create-an-mde-accde-or-ade-datab might help?
干杯，
Andy
这篇关于无法编译MS Access2013应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
