Problem about MDE ~

[kelvin H via AccessMonster.com]

What is the significance of changing MDB to MDE ?
Is there any other way that can hidden the code wiithout converting to MDB?

I cannot convert my MDB to MDE (about 30 tables, 10 forms and 10 queries) ,
warned me "Microsoft Office Access was unable to convert this database to MDE.
..."
I've also try separate the tables to another new database. The problem still
happen when I tranfered the forms to there.
How can I solve it ?

Thanks

 

[Craig Alexander Morrison]

The problem is your code is not compiling, you need to fix this first.

In Access 97 open a module for editing and select the Menu item Debug,
Compile and Save All Modules and then deal with the errors and issues that
that creates. Depending on your situation you may need to do this several
times.

In Access 2003 open a module for editing using Microsoft Visual Basic and
select the Menu item Debug, Compile <projectname>, where projectname is the
name of your project, which may match the mdb filename if you have not
explicitly stated it.

You should ALWAYS split your related central database tables from your
application, however this has no bearing on the creation of an MDE.