StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18677757
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-09-07T20:44:51.077
FavoriteCount
0
LastActivityDate
2014-01-18T10:40:04.673
LastEditDate
2014-01-18T10:40:04.673
LastEditorUserId
1625883
OwnerUserId
1625883
ParentId
18429639
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You have many choices to do that: <h2>1. Use the Compiled Executable Version of Your MS Access Database File.</h2> You can compile your database into an Executable File. But I don't know that you can access to it from other Programming Languages like C# or not. I think you must search the Internet. <ul> <li>In MS Access 2013: Go to the File -> Save As -> Save Database As -> Make ACCDE "File will be compiled into an executable only file."</li> </ul> <img src="https://i.stack.imgur.com/Dm1FB.jpg" alt="Make an Executable file from the database."> <img src="https://i.stack.imgur.com/nWHaq.jpg" alt="Save the Executable file of the database in somewhere."> <ul> <li>In MS Access 2010: Go to the File -> Save & Publish -> Save Database As -> Make ACCDE</li> <li>In MS Access 2007: Go to the Database Tools ribbon tab -> Make ACCDE (in the Database Tools group)</li> </ul> <h2>2. Encrypt Database with the Password.</h2> You can save your MS Access database file with Password; in this way, you must set the Password in database connection string for accessing to it. <ul> <li>In MS Access 2013: Go to the File -> Info -> Encrypt with Password "Use a password to restrict access to your database. Files that use the 2007 Microsoft Access file format or later are encrypted."</li> </ul> <img src="https://i.stack.imgur.com/NR7xj.jpg" alt="Open File Menu."> <img src="https://i.stack.imgur.com/TslWz.jpg" alt="Open the database file."> <img src="https://i.stack.imgur.com/X7ap7.png" alt="Open the database file in Exclusive mode."> <img src="https://i.stack.imgur.com/RdO6R.jpg" alt="Encrypt the database file with Password."> <img src="https://i.stack.imgur.com/szM7s.jpg" alt="Add Password to the database for Encrypting."> Go to the File -> Info -> Decrypt Database "Removes the password from this database." <img src="https://i.stack.imgur.com/m4EuM.jpg" alt="Decrypt the database file."> <img src="https://i.stack.imgur.com/eMceh.jpg" alt="Enter Password for Decrypting database file."> <ul> <li>In MS Access 2010: Go to the File -> Info -> Encrypt with Password Go to the File -> Info -> Decrypt Database</li> <li>In MS Access 2007: Go to the Database Tools ribbon tab -> Encrypt with Password (in the Database Tools group) Go to the Database Tools ribbon tab -> Decrypt Database (in the Database Tools group)</li> </ul> <h2>3. Backup Your Main Database.</h2> You can create a backup version of your database in somewhere else; you can do this with two ways: <ol> <li>Write some codes for create a backup file from your database with the backup ability of the MS Access. You can do this manually from MS Access program: <ul> <li>In MS Access 2013: Go to the File -> Save As -> Save Database As -> Back Up Database "Back up important database regularly to prevent data loss."</li> </ul> <img src="https://i.stack.imgur.com/84y8a.jpg" alt="Create a Backup file from the database."> <img src="https://i.stack.imgur.com/q2oDV.jpg" alt="Save the Backup file of the database in somewhere."> <ul> <li>In MS Access 2010: Go to the File -> Save & Publish -> Save Database As -> Back Up Database</li> <li>In MS Access 2007: Go to the Microsoft Office Button -> Manage -> Back Up Database (under Manage this database)</li> </ul></li> <li>For creating A backup file, you can simply create a copy of your file with writing some codes to do that.</li> </ol> The scenario for doing both is as follows: Add or Call your codes for closing time of your application program that is closed by the end-user. Run your codes in the background Thread(s). Copy or back up it in somewhere like as follows: <ul> <li>%WINDIR%..\ProgramData\YourSubFolder(s)</li> <li>%USERPROFILE%\AppData\Local\YourSubFolder(s)</li> <li>%USERPROFILE%\AppData\LocalLow\YourSubFolder(s)</li> <li>%USERPROFILE%\AppData\Roaming\YourSubFolder(s)</li> <li>Somewhere else like: <ul> <li>Another folder in your program root folder or sub-folders(s)</li> <li>Another folder in where you want</li> </ul></li> <li>Etc.</li> </ul> Hint: You can change attributes of your database file (in the root folder or sub-folder(s) of your program) and/or its backup file (in somewhere else) to the Read-only, Hidden, System, Read-only + Hidden, Read-only + System, Hidden + System or Read-only + Hidden + System for increasing security. <img src="https://i.stack.imgur.com/JAUdJ.jpg" alt="Open Properties of the database file."> <img src="https://i.stack.imgur.com/Mmcvb.jpg" alt="Change Attributes of the database file to the Hidden."> <img src="https://i.stack.imgur.com/92p85.jpg" alt="Apply Hidden Attribute on the database file."> <img src="https://i.stack.imgur.com/XRhrw.jpg" alt="Change Attributes of the database file to the Read-only."> <img src="https://i.stack.imgur.com/RjwQ5.jpg" alt="Copy the Path of the database file."> <img src="https://i.stack.imgur.com/TrRRH.jpg" alt="Run Windows OS Command Prompt."> <img src="https://i.stack.imgur.com/wW3Mu.jpg" alt="Open Windows OS Command Prompt window."> <img src="https://i.stack.imgur.com/83xkB.jpg" alt="Type "attrib +h +s " with Paste the Path of the database file."> <img src="https://i.stack.imgur.com/NFQ4g.jpg" alt="Complete typing "attrib +h +s E:\Rostami\Myself\Programming\Access""> <img src="https://i.stack.imgur.com/DWipv.jpg" alt="Type Remaining Part of the database file Path (some of the initial characters [\da])."> <img src="https://i.stack.imgur.com/d1t20.jpg" alt="Press "Tab" key on the keyboard for completing the name of the database file."> <img src="https://i.stack.imgur.com/tnfY8.jpg" alt="Press "Enter" key on the keyboard for applying Hidden + System attributes on the database file."> <img src="https://i.stack.imgur.com/Z7e0S.jpg" alt="Change Attributes of the database file to the Hidden + System."> <img src="https://i.stack.imgur.com/P7ggv.jpg" alt="Apply Hidden + System Attributes on the database file."> <img src="https://i.stack.imgur.com/a2i5N.jpg" alt="Press "Enter" key on the keyboard for applying System attribute on the database file."> <img src="https://i.stack.imgur.com/Fowsf.jpg" alt="Change Attributes of the database file to the System."> <img src="https://i.stack.imgur.com/p9GTD.jpg" alt="Apply System Attribute on the database file."> <img src="https://i.stack.imgur.com/NR9UU.jpg" alt="Press "Enter" key on the keyboard for removing Hidden + System attributes on the database file."> <img src="https://i.stack.imgur.com/Mx1n2.jpg" alt="Remove Hidden + System Attributes from the database file."> <img src="https://i.stack.imgur.com/2nzfQ.jpg" alt="Apply none Attribute on the database file."> <ul> <li>You can't see Hidden files in default mode of displaying items; so, for see Hidden items, you must do the following:</li> </ul> <img src="https://i.stack.imgur.com/gaBWN.jpg" alt="Show Hidden items from Folders Ribbon."> or <img src="https://i.stack.imgur.com/mFvPl.jpg" alt="Open Folder Options dialogue box."> <img src="https://i.stack.imgur.com/ykTAq.jpg" alt="Show Hidden items from Folder Options dialogue box."> <ul> <li>You can't see System files in default mode of displaying items; so, for see System items, you must do the following:</li> </ul> <img src="https://i.stack.imgur.com/xt8EZ.jpg" alt="Show System items."> <img src="https://i.stack.imgur.com/Rrg43.jpg" alt="Confirm to show System items."> With doing this scenario, you can add some codes for running in the start-up time of your program for checking is there Database in its folder or not. And if it can't find the main database, just copy your database simply from backup folder to its initial folder in your application folder/sub-folder(s). <h2>4. Change the Security Attributes of the Main and Backup Database.</h2> You can change the security attributes for the Main Database (in the root folder or sub-folder(s) of your program) and its backup file (in somewhere else) to restrict access to both of them as follows: Add or Call your codes in closing time of your application program that is closed by the end-user. Run your codes after completing background Thread(s) for backup the Main Database (if you're used Backup Scenario). These codes must change the Security attributes to the specific Windows OS or User-defined (must define by you if you want to use it) Group or User. With this method, when program isn't running, no one can access to both database files. Remember that you must add or call some codes for changing the Security attributes of both databases in start-up time of your application program; because they must accessible by the application. <img src="https://i.stack.imgur.com/ctVIg.jpg" alt="Open Windows OS Computer Management window."> <img src="https://i.stack.imgur.com/23lcL.jpg" alt="Open New User window."> <img src="https://i.stack.imgur.com/Yutzj.jpg" alt="Create new user."> <img src="https://i.stack.imgur.com/2hZ60.jpg" alt="Create a new user with entered data."> <img src="https://i.stack.imgur.com/2wIrU.jpg" alt="Open new user Properties window."> <img src="https://i.stack.imgur.com/Owe76.jpg" alt="Remove all items that new user is member of them."> <img src="https://i.stack.imgur.com/IgwOx.jpg" alt="Add new item for that new user becomes member of it."> <img src="https://i.stack.imgur.com/P9owA.jpg" alt="Find Administrators Group."> <img src="https://i.stack.imgur.com/ORSlB.jpg" alt="Add Administrators Group."> <img src="https://i.stack.imgur.com/pVKK8.jpg" alt="Apply changes to new user."> If you want to use a Group, you can do the following: <img src="https://i.stack.imgur.com/4v73g.jpg" alt="Open New Group window."> <img src="https://i.stack.imgur.com/0KvqZ.jpg" alt="Add data and Members."> <img src="https://i.stack.imgur.com/OT2yV.jpg" alt="Show Advanced part of the Select Users window."> <img src="https://i.stack.imgur.com/Vj2SX.jpg" alt="Find Users or Built-in security principals."> <img src="https://i.stack.imgur.com/vCijW.jpg" alt="Find new User."> <img src="https://i.stack.imgur.com/IIukE.jpg" alt="Add new User."> <img src="https://i.stack.imgur.com/hy0Sk.jpg" alt="Create new group."> <img src="https://i.stack.imgur.com/k52mS.jpg" alt="Create a new group with entered data."> <img src="https://i.stack.imgur.com/QdEiH.jpg" alt="Open Properties window of the database file."> <img src="https://i.stack.imgur.com/mbuRT.jpg" alt="Open Advanced Security Settings window of the database file."> <img src="https://i.stack.imgur.com/sbQMN.jpg" alt="Disable inheritance."> <img src="https://i.stack.imgur.com/ClTi4.jpg" alt="Remove all inherited permissions from the database file."> <img src="https://i.stack.imgur.com/pknNJ.jpg" alt="Change Owner."> <img src="https://i.stack.imgur.com/gpEtj.jpg" alt="Save Changes."> <img src="https://i.stack.imgur.com/mrwr2.jpg" alt="Confirm to apply changes."> <img src="https://i.stack.imgur.com/vCijW.jpg" alt="Find new User."> <img src="https://i.stack.imgur.com/IIukE.jpg" alt="Add new User."> <img src="https://i.stack.imgur.com/N1tz9.jpg" alt="Open Permission Entry window of the database file."> <img src="https://i.stack.imgur.com/VCxLD.jpg" alt="Select a principal."> <img src="https://i.stack.imgur.com/vCijW.jpg" alt="Find new User."> <img src="https://i.stack.imgur.com/IIukE.jpg" alt="Add new User."> <img src="https://i.stack.imgur.com/uifn1.jpg" alt="Apply Changes."> <img src="https://i.stack.imgur.com/cWkAB.jpg" alt="Apply Changes."> <img src="https://i.stack.imgur.com/HhHLc.jpg" alt="Apply Changes."> <img src="https://i.stack.imgur.com/dXMtG.jpg" alt="You can't open the database file."> <img src="https://i.stack.imgur.com/nyj8K.jpg" alt="Provide administrator permission to delete the database file."> <img src="https://i.stack.imgur.com/mRvwo.jpg" alt="You can't delete the database file."> <img src="https://i.stack.imgur.com/dVd2M.jpg" alt="Provide administrator permission to copy the database file."> <img src="https://i.stack.imgur.com/mRvwo.jpg" alt="You can't copy the database file."> <img src="https://i.stack.imgur.com/ffRnD.jpg" alt="Provide administrator permission to move the database file."> <img src="https://i.stack.imgur.com/mRvwo.jpg" alt="You can't move the database file."> <img src="https://i.stack.imgur.com/QdEiH.jpg" alt="Open Properties window of the database file."> <img src="https://i.stack.imgur.com/i9gFD.jpg" alt="You can't see the properties of the database file."> In order of what I mentioned above, THE BEST SOLUTION IS: <ul> <li>Hybrid method:</li> </ul> Combine all methods together for achieve to the better and more secure method: Compiled Executable Version of the MS Access Database File + Encryption with the Password + Backing Up the Main Database + Changing Security Attributes for Both Databases
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POwhat if user deletes some file from installed folder
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMRS1367
UserOwnerUserId
1. USMRS1367
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POwhat if user deletes some file from installed folder
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COYour answer is very clean and well explained ,thank you ,using this I came to know about database security in more depth
 singulars
 PostPostId
 PO
 UserUserId
 USDurga
2. COHow does this answer this original question?
 singulars
 PostPostId
 PO
 UserUserId
 USCharlie Brown

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.