Yes, you can use the MDE file with Access. Be sure to
find out its version so you can use it with the correct
release of MS Access.
The following is what is essentially stated in the MS
Access help files: If your database contains MS VBA
code, an MDB file converted to a MDE file compiles all
modules, removes all editable source code, and compacts
the destination database. Your VBA code will continue to
run, but it cannot be viewed or edited. Saving your
database as an MDE file secures your VBA, forms, and
reports. An MDB file allows design views of your VBA,
forms, and reports and would permit anyone access to do
as they wish in these highly critical areas.
Your MDE database will continue to function normally--you
can still update data and run reports. Additionally, the
size of the MDE database will be reduced due to the
removal of the code, so memory usage is optimized, which
will improve performance.
