S
Steven
I have an access database on a network. What is to
prevent an upset user from one day copying the database to
their C:\ Drive ; waiting a few days and then copying
that old database back over the current day.
Here is a current plan I have:
If you cannot prevent them from copying and deleteing is
there a good way to test the database to validate that it
is the current database. I was thinking of creating a
Tester database in a directory that nobody knows about and
everytime a trasaction is processed in the main database,
(ie MainDB), it would take an incremental transaction
number and log it to the Tester database. For example,
MainDB TransLog# is 1000. This means the TestDB TransLog#
must be 1000. When a user tries to append or update in
the MainDB it will test these numbers. If they are not
equal then the MainDB will stop everyone by a value in a
special table. If the numbers agree then the
append/update will proceed in the MainDB and the TransLog#
in both Dbs will increment to 1001. This way if someone
tries something sneaky, and there has been a new
transaction, then the TransLogs will not agree. That is
unless that person understands my system and knew how to
keep the Tester DB with the MainDB, which I doubt they
would know. Is this a good idea or is there an easier way.
Thank you for your help.
Steven
prevent an upset user from one day copying the database to
their C:\ Drive ; waiting a few days and then copying
that old database back over the current day.
Here is a current plan I have:
If you cannot prevent them from copying and deleteing is
there a good way to test the database to validate that it
is the current database. I was thinking of creating a
Tester database in a directory that nobody knows about and
everytime a trasaction is processed in the main database,
(ie MainDB), it would take an incremental transaction
number and log it to the Tester database. For example,
MainDB TransLog# is 1000. This means the TestDB TransLog#
must be 1000. When a user tries to append or update in
the MainDB it will test these numbers. If they are not
equal then the MainDB will stop everyone by a value in a
special table. If the numbers agree then the
append/update will proceed in the MainDB and the TransLog#
in both Dbs will increment to 1001. This way if someone
tries something sneaky, and there has been a new
transaction, then the TransLogs will not agree. That is
unless that person understands my system and knew how to
keep the Tester DB with the MainDB, which I doubt they
would know. Is this a good idea or is there an easier way.
Thank you for your help.
Steven