Compile error when using the Run Time version

[GeorgeDurkee]

I have a database that runs fine under full Access 97.&nbsp;&nbsp;It has the data and the forms seperated and I have a routine to relink them at the start of the the application.<br><br>I created a distribution set and included te run-time version of Access and installed it on a machine without Access installed.<br><br>The distribution setup had all of the external controls defined on my system installed as well as the database and related files.<br>&nbsp;<br>I get a compile error in hidden module when the aplication starts. I un-hid every object and tried again.&nbsp;&nbsp;I got the same compile error.<br><br>I started it from Windoews Explorer by double clicking on the MDB file.<br><br>Any ideas how I can even find out what is wrong, since it works fine on my system.&nbsp;&nbsp;It only doesn't work on a system where there is no Access.<br><br>Thanks

 

[DougP]

I suspect you have some sort of VBA syntax error.<br>Which running Access would not show up<br>Compiling on the otherhand checks every nook and crany for good code.<br>Also look carefully at your &quot;ERROR&quot; mesage when compiling it might shed light on th exact error.<br><br>Open your module in design view and click &quot;Debug&quot; &quot;Compile all loaded modules&quot;.&nbsp;&nbsp;<br>See if that will flush out the culprit.<br><br>Also being a Visual Basic Pro programmer I know that there are sometimes two differnt .OCX's. One for run time amd one which gets compiled in. Make sure you have both available.<br><br>Does Access compiler allow you to add &quot;Included files&quot;?<br>make sure you have everything it might need.<br><br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[GeorgeDurkee]

The only error I get at run time is &quot;compile error in hidden module.&quot; There is no error number or indication of how to look at the error.<br><br>Since it runs fine under full Access, there is no compile error when I compile or run on the development system.<br><br>If I load the runtime on the developer system, then it runs Access, not the run time version, and the application runs fine.<br><br>Any ideas on how to check the error at run time without Access?