So how do you create an .mde file?

  • Thread starter Thread starter el zorro
  • Start date Start date
E

el zorro

Stupid question, I guess. I have a database split into a
front end and a back end. I'd like to keep the users from
futzing with my designs, so I guess an .mde file would be
the ticket. Plus, the Access Performance analyzer has
recommended that I use .mde's. SO it looks like I should
convert the front end to an .mde file.

But I've poked all around the application, and I can't
figure out how to do the conversion. Can you help me out
here?
 
Tools | Database Utilities | Make MDE file

Note that if you're using Access 2002 or Access 2003, the default file
format is Access 2000. You'll need to convert your database to the newer
format (Tools | Database Utilities | Convert Database) before you can make
an MDE.

Also, it's probably a good idea to try and compile your database first
(Debug | Compile), since you won't be able to create an MDE unless the
application can compile cleanly.
 
THanks-- I am working in Access 2000. ANd though I don't
understand how Access 2000 can offer me the option to
convert to Access 2002, it does! (Were the programmers
psychic?) If I make this conversion, will Access 2000
then give me the option to convert to an MDE, or will I
need to upgrade to the newer version? WIll Access 2000
users be able to run MDEs?
 
You sure Access 2000 is giving you an option to convert to Access 2002? I
don't have Access 2000 installed, but I thought the only option available
was to convert to previous version.

Access 2000 will only be able to make an MDE from a file in Access 2000
format.
 
Back
Top