Executable Access

[Jahangir]

I have made Access databse with all functions and forms. But now I want to generate executabel databse in which user does not have permission to change design of databse. How i can do this.
PLz help.

[Tanis]

Split the database into front end,forms reports,macros and modules and back end,tables. Then make it an MDE file. Once your database is split, you can distribute it as an MDE or MDB. The back end will remain an MDB
This way, if changes are required, it is simply a matter of altering the original front end MDB, make an MDE if you wish, and distibute the front end to your users.

[PEB]

Take care my frien this is executable only by MS Access and Ms Access runtime.. Not by Windows...

:)

[MMcCarthy]

Split the database into front end,forms reports,macros and modules and back end,tables. Then make it an MDE file. Once your database is split, you can distribute it as an MDE or MDB. The back end will remain an MDB
This way, if changes are required, it is simply a matter of altering the original front end MDB, make an MDE if you wish, and distibute the front end to your users.

IMPORTANT

Keep a copy of your mdb for future changes as you cannot edit the mde.