Users can simply click Open to open the file. If users receive the security warning as seen in the above screenshot, it is probably because the executable database file is being opened from a non-trusted location. accde format.Īnd if it's a split database, they won't be able to edit the design of the tables (as those are in the back-end database). We'll now save the Music database that we've created throughout this tutorial as an executable-only file in. Save a Database as an Executable-only File a non-compiled database), on the other hand, allows users to modify these objects and change the VBA source code. accde file.Ī normal Access database (i.e. Users cannot change the design of objects such as forms, reports, and macros in an. accdb extension of the regular Access database).Īn Access compiled binary file contains no VBA source code. An Access compiled binary file is saved with an. If you plan to distribute your Access database to users, consider saving it as an executable-only file.Īn executable file (or a compiled binary file) is a database application file that has been saved with all the Visual Basic Access (VBA) code compiled.
This prevents users from modifying the database design, while still providing the functionality required by most users. You can save an Access database as an executable-only file to enhance security and improve performance.
0 kommentar(er)
