Click here to Skip to main content
15,900,258 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all visitors
i have create one access file that set password. so when i open that file, i need to input password.this is the security of MS.Access.
Is it possible that when i delete MS Access file, i need to input password?
if it is possible, how can i do?

Best Regards,
TONY
Posted

1 solution

The Access password is used only to protect the 'inside' of the database file. Since the database is just a file, it cannot protect itself from operating system operations.

However, what you can do is to set proper privileges on the file (or directory) using windows security. For example you can grant read and write but deny (or not grant) delete. This doesn't protect the contents of the file since a person with write privileges can destroy the contents but depending on your situation it may be usable.

If you don't give or deny the delete permission on the file, remember also to check if the users have "delete subfolders and files" privilege in that directory. This is because if you have that privilege it overrides the lack of a single file deletion privilege.
 
Share this answer
 
Comments
soeun tony 15-Aug-11 21:15pm    
Thanks for ur reply
I'll follow your idea.
This is a good idea that i forget to do.
Thanks
Wendelius 16-Aug-11 0:43am    
No problem. If you like you can mark the answer as accepted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900