can't create a MDE file

[Don]

I am trying to create a MDE file from my database but the
option is not highlighted in the Tools/Database Utilities
drop down menu. This happens on all the databases I try
to create a MDE file. Any settings that I need to make
before creating a MDE file? Any help will be greatly
appreicated.

Thanks in advance.

 

[Joan Wild]

You con't mention the version, but I'll venture that you are using 2002 or
2003. However your database is in 2000 format (you can check this by
looking at the title bar of the database window). By default 2002/2003
create new databases in 2000 format - you can change this behaviour in
Tools, Options.

If you go to Tools, Database Utilities, Convert, you'll see the option to
convert your database to the correct format. 2002 can only create a MDE from
a 2002 form.

Then open any code module (or hit Ctrl-g) and Debug, Compile and then hit
save.

You should then be able to create the MDE.

 

[Guest]

Thanks for taking the time to help! Needed to recompile
the code. Had an undefined function.

I'm new to Access so I was trying to create a MDE with a
database opened in the Access window! Once that was
remedied I found the other problem. Thanks again!