编译一个Access 2007 ACCDB到ACCDE [英] Compiling an Access 2007 accdb into accde
问题描述
我试图使用内置的制作ACCDE功能的访问，使独立的应用程序，它连接到一个SQL Server 2008的后端。当我运行make ACCDE我收到指出太多的参考TABLEID正在使用（限据称大约2048）。
I'm trying to use the built in Make ACCDE functionality in access to make a standalone application that interfaces to an SQL-Server 2008 back end. When I run the Make ACCDE I receive an error that states that too many TableID references are being used (the limit is stated to be around 2048).
经过反复试验（删除形式，直到编译）我发现它的形式是造成问题。看来，如果我删除所有的VBA $从表格C $ C编译。
Through trial and error (deleting forms until it compiles) I've discovered which form is causing the issues. It seems to compile if I delete all the VBA code from the form.
我想知道是否有人遇到了这个问题之前，如果有，导致它的特定问题？现在几次，我遇到这个问题，这是一个真正的痛苦经历我的code删除它的一半来查找错误的来源。
I was wondering if anyone has run into this problem before and if there is a specific issue that causes it? I've run into this problem a few times now and it's a real pain to go through my code deleting half of it to find where the error is coming from.
推荐答案
对于未来的编码，你应该确保你遵循良好的编码习惯：
For future coding, you should make sure you follow good coding practices:
-
在VBE选项，关闭COMPILE需求和确保要求变量声明为开（这将导致新的模块将与显式的选项默认创建的）。
in VBE options, turn off COMPILE ON DEMAND and make sure REQUIRE VARIABLE DECLARATION is turned ON (this will cause new modules to be created with OPTION EXPLICIT by default).
添加编译按钮，工具栏在VBE所以它很方便。当编码，创下code每隔几行之后编译按钮（每编译后保存）。这将prevent你写的code太多的不可编译的线条，所以它会更容易解决这些问题是编译。
add the compile button to your toolbar in the VBE so its easily accessible. When coding, hit the compile button after every few lines of code (and SAVE after each compile). This will prevent you from writing too many uncompilable lines of code, so it will be easier to fix them to be compilable.
定期，让你的数据库的备份和反编译和重新编译它。这将清理出来，在编译的P code已经积累（反编译去除所有的编译P- code，只保留了典型的code文本），并可以将其排出的有$编译错误的任何污物p $ pviously被隐藏的损坏的P- code。
on a regular basis, make a backup of your database and decompile and recompile it. This will clean out any crud that has accumulated in the compiled p-code (decompile strips all the compiled p-code and leaves only the canonical code text) and can flush out compile errors that had previously been hidden by corrupted p-code.
通过遵循这些最佳实践，你将很少遇到code腐败。
By following these best practices, you will hardly ever encounter code corruption.
这篇关于编译一个Access 2007 ACCDB到ACCDE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
