MS Access 2007 .exe?

[JPRENG]

Im slightly unsure of how to do this. I want to compile(?) my database so I can distribute it to user who can add/change/delete records but so they can't mess about with the form design etc? How di I do this? Thanks.

 

[Galaxiom]

You can't make an exe but you can convert the front end of the database to accde
The command is in the ribbon.

User will need to have Access or the Access runtime installed.

Be sure to keep the original file somewhere safe as the conversion is one way

 

[JPRENG]

Will they be able to add and save new records etc this way?

 

[Galaxiom]

Yes. They can do everything but modify the code, forms and reports.

The can even modify the structure of the tables and queries but we try to stop them.

 

[JPRENG]

I have converted my accdb to accde but when a record is added it wont allow it to be saved to the database. And the save option is ghosted out.

 

[Galaxiom]

Save is greyed out because it is used to save the form design which is disabled in accde.

Records are saved automatically to the table when you move to another record or close the form.

 

[JPRENG]

Thanks for that. Just one more thing, I have got a "Home Page" form where the user can click a button and go to a certain form, however when I export my DB to an accde the buttons don't work. My code is;

Private Sub btnEmployee_Click()

DoCmd.OpenForm "EmployeeDetails"

End Sub

 

[Galaxiom]

All code should work fine. Is this on the same PC as the accdb runs?

Code is disabled completely by default on some systems. On others it prompts for the user to approve code to be allowed to run.

 

[JPRENG]

Yes it's on the same pc that the accdb runs. It just doesn't seem to work?

 

[SOS]

It needs to be in a Trusted Location. See this and see if it helps