469,366 Members | 2,281 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Shared Access File

180 100+
How can i set my shared access file cannot be deleted by other people in LAN?
Jan 30 '12 #1

✓ answered by NeoPa

Within any Windows Domain the file permissions are NTFS compatible, and that includes a permission to delete. If users don't have this permission set then they will be unable to delete the file. Be very careful not to let anyone set the Deny Permission for Delete as that could cause your systems and/or administrators to be unable to delete it too.

PS. This is a Windows question and not related to Access or VBA.

5 1205
Rabbit
12,516 Expert Mod 8TB
You can't. Write permissions are required to modify the data in the database and that includes delete permission. There's no permission that is only for delete.
Jan 30 '12 #2
eneyardi
180 100+
So how can i protect my shared files? My access program is a LAN base
Jan 30 '12 #3
sierra7
446 Expert 256MB
Hi.
I'm not a network guru but I know you can locate the backend in a folder on the server which is hidden to general uses. The front-end explicitly links to this file via the known folder-name but the users cannot see it to delete it or steal data by copying to pen-drive.

If they can get into what was the 'Database Window' they can stil wreck havoc.

Which reminds me that I must stop them pressing F11 in Access 2010!

S7
Jan 30 '12 #4
NeoPa
32,185 Expert Mod 16PB
Within any Windows Domain the file permissions are NTFS compatible, and that includes a permission to delete. If users don't have this permission set then they will be unable to delete the file. Be very careful not to let anyone set the Deny Permission for Delete as that could cause your systems and/or administrators to be unable to delete it too.

PS. This is a Windows question and not related to Access or VBA.
Jan 30 '12 #5
eneyardi
180 100+
Thanks a lot guys for your quick reply.
Feb 1 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Ernesto | last post: by
13 posts views Thread by Elton Cohen | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.