UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Protecting Database From Stolen, Access 2013    
 
   
Alhakeem1977
post Sep 7 2017, 02:52 PM
Post#1



Posts: 103
Joined: 8-July 17



I have got MS Access database back end and front end with a backup function on daily basis for both the back and front end. I want to implement it at a shared network.

How can I protect it from copying or stolen by the users without accruing any problem while backup process?
Go to the top of the page
 
theDBguy
post Sep 7 2017, 02:56 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,950
Joined: 19-June 07
From: SunnySandyEggo


Access is a file system database, so the only way to prevent copying is to not give the potential thief any permission to access the files' location.

Just my 2 cents...
Go to the top of the page
 
MadPiet
post Sep 7 2017, 03:59 PM
Post#3



Posts: 2,602
Joined: 27-February 09



Use SQL Server Express as a back end? Then all the data stays there. Scales better too.
And you can grant execute rights on some views and stored procedures and fully deny to anything else (if you want) to selected groups. And it's stored in a location that your average user has no rights to... =)
Go to the top of the page
 
MadPiet
post Sep 7 2017, 04:25 PM
Post#4



Posts: 2,602
Joined: 27-February 09



Except that doesn't work if it's a malicious user. Because Access is file-based, the user needs rights to the directory the file is in.
Go to the top of the page
 
nvogel
post Sep 8 2017, 01:12 AM
Post#5



Posts: 891
Joined: 26-January 14
From: London, UK


You cannot protect an Access database from anyone who uses it or otherwise has access to it. If security is a requirement then use a server DBMS such as Oracle, SQL Server, PostgreSQL.
Go to the top of the page
 
DanielPineault
post Sep 9 2017, 01:55 PM
Post#6


UtterAccess VIP
Posts: 6,273
Joined: 30-June 11



You may benefit from reviewing: Securing Your MS Access Database Front-End
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2018 - 02:14 PM