Cannot Create MDE File

[allboutdB]

Hi there,

I am getting an error when i try to make an MDE file I have a database that is split into forms and back end tables. I get an error that i have too many forms or modules( i only have around 30 forms) , is there a limitation to the number of forms or module you can have in order to successfully make and MDE file.

Thanks

 

[pbaldy]

The usual culprit in this situation is code that won't compile. Does yours?

 

[allboutdB]

not all of it there might be a module or two that wouldn't compile, but if i fix that would it work?

Cheers

 

[pbaldy]

As I said, it's the usual culprit. You can't create an mde if the code won't compile.

 

[allboutdB]

Ok i will try cleaning up the code a 100% hope fully it will work after that
Thank you

 

[Khalid_Afridi]

Try to compile all your VBA code. use Option Explicit before you use any variable in your VBA code so you will not get any compilation error.

Khalid