Convert application to Runtime Mode in Access 2007

Overview

Access Forms let you create a user-friendly interface to end-user, it can also restrict what your users can view/modify. However user can still modify your table directly if your application is not run in Runtime Mode. Below shows the steps to convert your Access 2007 application to runtime before you put it to production.

Reference

Convert your Access 2007 application from design to runtime mode by changing its extension

Steps

1. Open the folder that contains your application (with .accdb extension)
2. Ensure that extension is shown in filename (this can be set in "Folder Options"),  rename the application to have .accdr extension (e.g. "myApp.accdb" rename to "myApp.accdr")
3. Finished!