Permissions

K

Karl Burrows

I have an Access database (2002, 2003 users). I have setup read only and
read/write permissions, but need to take it a step further. If they have
read/write, I don't want them to be able to go into design mode and make
changes to forms, reports, queries, etc. I have found someone likes to
"play" and has changed things on the database like locking fields, etc.
Nothing major and we keep backups, but just want to reduce potential
reporting issues from the database.

Thanks!
 
L

Larry Daugherty

Hi Karl,

First, Each user should have their own copy of the front end on their PC.

Second, distribute the front end in MDE format rather than MDB. That way,
do one can get into the front end and mess with the design.

Tony Toews provides FE Updater for free from his web site to help manage the
concurrency of the distributed front ends.

HTH
 
K

Karl Burrows

We don't want each user to have a front end copy since changes are made
constantly. We need to make sure one update isn't overwritten by another
update concurrently. Is this a bad thing?

Do you have any good articles for splitting a database and creating a MDE?

Thanks!

Hi Karl,

First, Each user should have their own copy of the front end on their PC.

Second, distribute the front end in MDE format rather than MDB. That way,
do one can get into the front end and mess with the design.

Tony Toews provides FE Updater for free from his web site to help manage the
concurrency of the distributed front ends.

HTH
 
A

Arvin Meyer

Karl if you want to use Access on a network, you need to have a split
database with a copy on each user's workstation. Anything else invites
corruption. Only 1 person should be working on the front-end at a time and
that front-end can reside on the server.

Splitting the database is easy, there's even a wizard: Tools ... Database
Utilities ... Database Splitter

In addition to Tony Toews AutoUpdaterFE, I have one at:

http://www.datastrat.com/Download/Starter.zip

You can even write a simple batch file to xcopy the server copy at every
database startup.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
L

Larry Daugherty

Hi Karl,

The FE Updater from Tony Toews exists just to address the issue of keeping
the individual user's front end current. At start up there is a test
against the reference Front end on the server to see if it is more recent.
If it is then the newer version replaces the older version on this user's
PC. Putting in the FE Updater is a bit of work but then the process is
almost transparent.

In Help look up "Database Split" and it will get you going.

For making an MDE, Compile your front end without errors. Then
Tools|Database Utilities|Make an MDE file.

HTH
 
Top