G

[Access Database to *.exe]

how do i convert a database file of MS Access to an *.exe file? So
that i can work with that database in a computer with MS Access.
So that just the front end, forms appear.

Thanks in advance

 

[Duane Hookom]

You can't make an MDB into an EXE. You would need to deploy the mdb with a
version of Office Developers Edition or re-write the application with some
other programming language.

 

[Keith Hobbs]

You can't make an exe but you can hide class/module code
etc from users by making an MDE file (Access 97).

To do this open the database in question. Go to the Tools,
Database Utilities menu and choose make MDE file.

Select the folder you want the file in and click the save
button.

You may also find it useful to hide the database window so
the users cannot directly access tables etc (Tools Start
up and uncheck display database window)

Hope this helps. I think the client computer should have
Access installed for this to work.


Keith Hobbs
Office for National Statistics
UK