ورود

View Full Version : اشكال در تبديل يك بانك حجيم اكسس به MDE



soroush_k12
پنج شنبه 10 آذر 1390, 18:17 عصر
با سلام خدمت دوستان
من فايل اكسسي دارم كه كمي اشياي اون زياد شده و در هنگام تبديل شدن به ام دي اي اين ارور رو ميده .
معني ارور رو ميدونم ولي آيا راه حلي نداره؟
با تشكر



This error is usually associated with compiling a large database into an MDE file.  Due to the method used to compile the database, a considerable number of TableID references are created for each table.  The Microsoft Jet database engine version 4.0 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 Jet 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.
More information about this error message online. (http://watson.microsoft.com/dw/errormessages.asp?ProductName=Office11&EventSource=OfficeErrorMessages&EventID=10010&Language=1033&productBuild=11.0.5525.0)

karimitabar
یک شنبه 07 اسفند 1401, 14:31 عصر
با سلام خدمت دوستان
من فايل اكسسي دارم كه كمي اشياي اون زياد شده و در هنگام تبديل شدن به ام دي اي اين ارور رو ميده .
معني ارور رو ميدونم ولي آيا راه حلي نداره؟
با تشكر



This error is usually associated with compiling a large database into an MDE file.  Due to the method used to compile the database, a considerable number of TableID references are created for each table.  The Microsoft Jet database engine version 4.0 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 Jet 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.
More information about this error message online. (http://watson.microsoft.com/dw/errormessages.asp?ProductName=Office11&EventSource=OfficeErrorMessages&EventID=10010&Language=1033&productBuild=11.0.5525.0)



با سلام
فایل vba رو کامپایل کنید. ایرادات رو برطرف کنید مشکل حل میشه