Table Security: Retricting Update queries to only run to one table

  • Thread starter Thread starter jon.ingram
  • Start date Start date
J

jon.ingram

I have a "web" or "network" of MS access databases with linked tables
that 50+ people use to enter their vacation time and worked hours. At
the end of the day all this entered information appends to a master
table that we use to report off of.

What has happened now is that one of our users has copied the database
to their desktop and is inadvertenly running a macro embedded in the
"exit" button that is appending to our master table and duplicating
records.

I understand that there is some detective measures here i.e. ask who
is doing this and ask them to use the DB on the network (there are
certain people tend not to listen) and perhaps run an update everyday
to delete duplicated records (what I do now but someone always tends
to run a report before we make the update and everything is out of
wack). I really need a preventitive solution.

So, is there a way for me to set properties on a table to only accept
updates and appended records from queries in a database that I
specify? For Example something that tells my table only allow updates
from these 5 queries which are housed in this database. If a query
from a different path tries to update the table then dont allow the
update. Any help would be great. Thanks in advance.
 
I have a "web" or "network" of MS access databases with linked tables
that 50+ people use to enter their vacation time and worked hours. At
the end of the day all this entered information appends to a master
table that we use to report off of.

What has happened now is that one of our users has copied the database
to their desktop and is inadvertenly running a macro embedded in the
"exit" button that is appending to our master table and duplicating
records.

I understand that there is some detective measures here i.e. ask who
is doing this and ask them to use the DB on the network (there are
certain people tend not to listen) and perhaps run an update everyday
to delete duplicated records (what I do now but someone always tends
to run a report before we make the update and everything is out of
wack). I really need a preventitive solution.

So, is there a way for me to set properties on a table to only accept
updates and appended records from queries in a database that I
specify? For Example something that tells my table only allow updates
from these 5 queries which are housed in this database. If a query
from a different path tries to update the table then dont allow the
update. Any help would be great. Thanks in advance.
Click to expand...

There is a basic flaw in your design and that flaw is the necessity to
duplicate data. I would suggest that the data is appended by your users
directly to the target table using a linked table. You've already mentioned
you have linked tables, why can't you use that method for this purpose?

Keith.
www.keithwilby.com
 
Back
Top