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    
post Sep 7 2017, 02:52 PM

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
post Sep 7 2017, 02:56 PM

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
post Sep 7 2017, 03:59 PM

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
post Sep 7 2017, 04:25 PM

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
post Sep 8 2017, 01:12 AM

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
post Sep 9 2017, 01:55 PM

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