You are here:

Using MS Access/Security to Access Project


QUESTION: How we can protect our Access 2010 project from stealing , copying, using from another person.

By Using MS-Access 2010 as front-end and back-end can we provide security to our project like other software (.Net / VB).

If any person copy our project on different location without our permission can we restrict to open the project and send mail directly  to us without knowing to pirates.

ANSWER: Hi Kundan,
Welcome again. Just like how we get a quick SMS no sooner you withdraw a large amount of CASH from an ATM, similarly we trigger an email no sooner someone loads the Access.ACCDB file with its first opening screen.
The code on the ON LOAD event should fire up an email to the Original author of the database. This security cannot be applied on the back-end database.

If you are so bothered about someone stealing data, then I must advice you to switch your backend to SQL-Azure. Your data can get access from only the front-end which has its user name and password. This can happen on the Internet from wherever in the world there is internet.

If you want to secure your data within the office then you must have SQL-Server 2008 R2 as your backend with MS-Access 2010 as front-end. It is very safe.

Do let me know your scenario.

Best regards
Manish Batola.

---------- FOLLOW-UP ----------

QUESTION: Here I commited my knowledge is very basic into this domain.  
And as I worked only older version of Access (i.e. access 2000)

On your advice 1 more query in my mind.

Even I use SQL Server 2008 R2 as back-end and MS Access 2010 as fornt-end. User can navigate to Tables tab and open the table or export it into another file.

Or s/he can change directly table value.

Hi Kundan,
The best way to secure your database is by hiding all the tables, and disabling the Shift key and the the Navigation bar.
I do that, it work. No headaches of anyone hacking a password or finding a gateway to import objects.

Best regards
Manish Batola.

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Manish Batola


ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions, Industrial Strength Invoicing and many more being added every year.


29+ yrs in the Software industry with 23yrs completely dedicated on more than 350 Various Microsoft Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Worked in various multinationals catering from Aerospace, Oil & Gas etc.

-BSc - Computer Science -MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineer (Software Development)

Past/Present Clients
Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Logistics & Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

©2016 All rights reserved.