Compile error (Access97)

Topic

New Reply

When I go to make the MDE file for my database, I get an error which reads:
Compile error in hidden module: From_frmDataInput
I know a MDE file can be made of this database, because I have done it before. I made some changes to other forms and now it is saying there is a error in this form. I dont know what could be the problem. Any help is appreciated.
Thanks

Reply | Quote

Replies

What happens if you do the following in the MDB file:
– Open any module (it can be a standard module or the module belonging to a form or report)
– Select Debug | Compile and Save All Modules.
Do you get any error messages?

Reply | Quote

thanks HansV, the debug pointed them out
I had a couple syntax errors

Reply | Quote

It is always a good idea to try to compile the code in your database before turning it over to the end users (to avoid complaints) and before you create an MDE (since the source code is removed from an MDE, Access must be able to compile it when creating an MDE).

Reply | Quote

It is always a good idea to try to compile the code in your database before turning it over to the end users (to avoid complaints) and before you create an MDE (since the source code is removed from an MDE, Access must be able to compile it when creating an MDE).

Reply | Quote

thanks HansV, the debug pointed them out
I had a couple syntax errors

Reply | Quote

What happens if you do the following in the MDB file:
– Open any module (it can be a standard module or the module belonging to a form or report)
– Select Debug | Compile and Save All Modules.
Do you get any error messages?

Reply | Quote

Have you tried any of the suggestions in this page of The Access Web?

Reply | Quote

Have you tried any of the suggestions in this page of The Access Web?

Reply | Quote