People with questions about securing an MS-Access database are generally referred to the Microsoft Access Security FAQ.
This does a pretty thorough job of explaining how you secure a single mdb file. This knowledge is however insufficient, given that it is strongly recommended – indeed virtually essential – to split every Access database into two separate files. (If you are unsure why, I give notes on the reasons at the bottom of the page.)
This page fills in the missing information, and emphasises one or two points which don't in my view get sufficient exposure in the FAQ. I have put it together on the basis of several discussions in the Access newsgroups and my own experience. It is applicable (to the best of my knowledge) to Access versions from 97 onwards.
One thing that it is important to understand before you start (but which in the FAQ is buried under a rather misleading title somewhere around page 9) is that it is not possible to make an Access database (or indeed any file-system-based database) very secure. You can secure it against people with no technical skills and against casual hackers. If the information in the database is only moderately sensitive, then this is probably sufficient.
But if security is really important then you need a server-based database, such as Oracle, SQL server or PostgreSQL.
The steps for setting up the secure database are as follows.
"Access executable" "front-end file" /wrkgrp "workgroup file"
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\ABCapplication\ABC.mde" /wrkgrp
It is easiest to construct the shortcut in a text-editor and paste it into the shortcut properties. Note that there should not be any line terminators, although the above example wraps. Note also that it is recommended to include the share name (e.g. \\fileserv1\) rather than the drive name (e.g. N:) in the network reference, to protect yourself against configuration differences.
Note that if differing configurations of the user desktops mean that it is not possible for every user to use the same shortcut syntax, then it gets a bit messy. Possible solutions, none of them really good, are:
As mentioned above it is important to split an Access database into a back-end containing the tables and a front-end containing everything else – forms, reports etc. This is for two reasons:
The only time it isn't necessary to split a database is when it is for your sole personal use.
In addition it is important that a separate copy of the front-end is distributed to every user to run on their own computer. This is because having everyone run a single copy in a network directory is likely to result in:
You might get away with a single front-end copy for a while, especially if you have a simple database with few concurrent users. Then again, you might not.