security of database

Topic

New Reply

Dear All
Has a database project and became a project ready, but how the program can be protected in a way you can not manipulate it, delete, or export tables or queries ..

Reply | Quote

Replies

You can compile your database into an mde file which will make it a runtime file only. In a mde database the user has no access to design view for any of the database objects. Any changes have to be made in the original mdb file and then converted again. However, though tables cannot be exported from a mde file you can still link to the tables from another database and you may be able to import them too.

Reply | Quote

Adding to Chuck’s comments, I presume when you mention project that you are not referring to an Access ADP project that uses a SQL Server back-end, but are working with either a .mdb file or a .accdb file. Forms and reports (and any VBA code) cannot be opened in design mode, but tables, queries and macros can be viewed and modified. If you are working with a .mdb format Access database, then there is the option to use Access User Security which gives fairly good control over who can do what to each object in the database. The tutorial The Secrets of Security, while somewhat dated, might get you started on the topic, and a search turns up numerous other tutorials and videos on the subject. Note however, that the .accdb format introduced in Access 2007 does not support that feature. You might also want to look at Introduction to Access 2010 security.

Reply | Quote

very very thank you all

Reply | Quote