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: 64
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?

Best Regards,

Al Hakeem1977
Go to the top of the page
post Sep 7 2017, 02:56 PM

Access Wiki and Forums Moderator
Posts: 71,230
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...

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
post Sep 7 2017, 03:59 PM

Posts: 2,264
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,264
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: 811
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: 5,452
Joined: 30-June 11

You may benefit from reviewing: Securing Your MS Access Database Front-End

Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 08:03 AM