Shared Access File

[eneyardi]

How can i set my shared access file cannot be deleted by other people in LAN?

[Rabbit]

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.

[eneyardi]

So how can i protect my shared files? My access program is a LAN base

[sierra7]

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

[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.

[eneyardi]

Thanks a lot guys for your quick reply.