Beste allemaal,
Ik wil graag een executable (.accde) maken van mijn database (access 2010), maar ik krijg onderstaande foutmelding:
groet, Patric
Ik wil graag een executable (.accde) maken van mijn database (access 2010), maar ik krijg onderstaande foutmelding:
Is hier een oplossing/workaround voor?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.
groet, Patric
Laatst bewerkt: