Secure Access Database from being copied

Posted on 2009-04-22
Last Modified: 2013-11-29
We use an Access 2003 database that is run from a termial server.  The users log into the TS and run the database from their desktop frontend shortcut.  The database is split with the backend database tables linked.
The concern by the management that an employee can copy the database and use it at another company.  I cannot figure a way to prevent the backend database file from being copied becuase all users need r/w acccess the the file.
My other option seems to be implimenting the Access Security via the security.mdw workgroup file.

1. Am i correct in assumming that the file is not safe from being copied onto a removable device by users?
2. Would the Access Security be a way to protect the file from being used if it was copied and taken offsite?

Question by:beyondt
    LVL 18

    Expert Comment

    Really no way to protect an Access database like that.

    Author Comment

    Any suggestions on how to protect it from being copied?
    LVL 18

    Accepted Solution

    Use a secure database server like SQL Server, Oracle, MySQL, PostGreSQL.

    Author Closing Comment

    Thanks.  That was what I figure but it was worth a shot.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now