MDE troubles

[hair]

Hi guys

I am using Access XP and I am trying to make a MDE of a db, but when I try the part for MDE in tools is grey, so unusable. I convert the database to 2000 format, the MDE option is not gray anymore, it even (looks like) work, but when I open the result is a .mdb not an .mde. So not working.
Did one of you guys had this problem?

Thanks in advance

 

[mousemat]

Before you can convert an MDB into an MDE you need to compile your code and remove all the unwanted code.

Open any form and then open the VBA window and remove all the code that doesn't belong there, for example any command buttons that you have deleted will leave their code behind.

Then from the VBA window click DEBUG and seect the first entry, keep clicking this until it goes grey, then your code has been compiled.

That should get you started

 

[hair]

I already compiled the code and eliminate the old one

 

[mousemat]

Mmm ok try this

What format is your current database in (it will tell you on top of of the database window) My guess is that it says 2000 format.

That being the case, close access completely, then just open up access from the access icon, not by the database.

Click tools, then convert database, then select access 2002. navigate to the database you want, then click OK.

Once you have converted the database, open access again, by the icon and select tools and make MDE file. navigate to the newley created access 2002 database then click Make MDE.

 

[hair]

funny
I did what u said, it worked
And it created the .mde
But
I still have access to the code and tables like in the mdb
ain't that funny
Thanks

 

[mousemat]

I must admit, that happened to me too, never used to though so not sure what that means.

I guess if you are making MDE files it might be a good idea not to show the database window