Making Exe's

[-- Paul --]

Hi,

can you save a form as an exe so users cannot make any changes, other than
data input? If so how?

Cheers

Paul

 

[Roger Carlson]

You cannot make your database into an EXE, however, you can convert you
application to an MDE, which will not allow any changes to the forms,
reports, macros, or modules. You do this at the Tools > Database Utilities

Make MDE. Bear in mind that you can never convert it back, so you must

keep a copy of the MDB handy.

 

[Cheryl Fischer]

No, but you can distribute your database as an MDE file rather than an MDB
file. MDEs do not permit design changes.

 

[Chuck]

...and you would also want to split your database into a front-end and
back-end. The back-end would contain the tables. The front-end (which you
will save as an mde file) will contain everything else.

 

[Philip]

Another thing once you have converted your database to an MDE. You will
still need Access on the computer you want to use your new MDE file on, or
have the Access Runtime installed on that computer.
Access runtime allows someone to run an Access Database on a computer
without Access, and without any Access licence.
The access runtime can be found on the Developer edition of Office, and I
believe in other places aswell.

Hope this helps.