SOLVED

Protect access database across network

%3CLINGO-SUB%20id%3D%22lingo-sub-2190323%22%20slang%3D%22en-US%22%3EProtect%20access%20database%20across%20network%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190323%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20an%20access%20file%20db%20(back%20end)%20shared%20across%20a%20Lan%20network%2C%20I%20want%20to%20make%20it%20unreadable%2C%20undeletable%2C%20and%20unwritable%20from%20any%20pc%20on%20the%20network%20except%20using%20a%20ui%20(front%20end)%20access%20file%20that%20I%20put%20it%20in%20network%20PCs%20(or%20using%20the%20main%20admin%20PC).%20How%20can%20I%20do%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2190323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2190919%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20access%20database%20across%20network%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190919%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F920882%22%20target%3D%22_blank%22%3E%40Yassirmosawi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20this%20is%20easier%20said%20than%20done.%20Access%20is%20simply%20not%20that%20secure.%20I%20hesitate%20to%20go%20into%20detail%20here%20because%20so%20much%20has%20already%20been%20written%20and%20there's%20a%20lot%20of%20reference%20materials%20you%20can%20use.%20%3CA%20href%3D%22http%3A%2F%2Fwww.mendipdatasystems.co.uk%2Fsecurity-challenges%2F4594398127%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHere's%20one%20of%20the%20more%20comprehensive.%3C%2FA%3E%26nbsp%3BStart%20here%20and%20continue%20your%20research%20with%20other%2C%20similar%20sites.%3C%2FP%3E%3CP%3EIn%20fact%2C%20if%20you%20are%20that%20concerned%20about%20the%20security%20of%20your%20data%2C%20you'd%20be%20well%20advised%20to%20look%20into%20a%20different%20database%20engine%2C%20like%20SQL%20Server%2C%20which%20CAN%20be%20made%20much%20more%20secure.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EGood%20luck%20with%20your%20search.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi, I have an access file db (back end) shared across a Lan network, I want to make it unreadable, undeletable, and unwritable from any pc on the network except using a ui (front end) access file that I put it in network PCs (or using the main admin PC). How can I do that?
1 Reply
best response confirmed by Yassirmosawi (New Contributor)
Solution

@Yassirmosawi 

Unfortunately, this is easier said than done. Access is simply not that secure. I hesitate to go into detail here because so much has already been written and there's a lot of reference materials you can use. Here's one of the more comprehensive. Start here and continue your research with other, similar sites.

In fact, if you are that concerned about the security of your data, you'd be well advised to look into a different database engine, like SQL Server, which CAN be made much more secure. 


Good luck with your search.