Access Types

[Mike]

Hi

I am Converting access 97 and 2000 to 2003, but i want to
know types of extensions of database like
97/2000/2002/2003. As per my knowledge all are .mdb just
want to make sure what is .mde, I converted few demos mdb
files to access 2003 why it compress database size.

Thank you

 

[Douglas J. Steele]

All versions of Access use the MDB extension. Since Access97, there's also
been an option to convert MDBs into MDEs. When you convert an MDB to an MDE,
Access compiles all modules, removes all editable source code, and compacts
the destination database. Your Visual Basic code will continue to run, but
it cannot be viewed or edited, and the size of your database will be reduced
due to the removal of the code.

 

[GVaught]

To add to Dougs explanation: If you do convert your mdb to an mde, never
delete the mdb file. This is your master original and any changes that you
make to the database must be made against the original master and then made
into a new mde. Guard the mdb with your life!