Two DataBases, One Secure and One Not

[B F Cole]

I have two identical data bases. One contains "real data" and is secured by
user id and password and a data base password. Works fine. I have a copy
of it for "training" that only has a data base password, a different
password. It was set up this way so that people training do not have to
enter a user id and password.

When a design change is made to the real data base, I currently export the
object from the real data base to the training data base and click "replace"
in the training data base. This also works but requires a lot of
"management" to be sure that they are in sync. Is there a way to copy the
entire "real" data base to the "training" data base, since they have
different levels of security?

Thanks for your ideas,
Bill

 

[Keith Wilby]

I have two identical data bases. One contains "real data" and is secured
by user id and password and a data base password. Works fine. I have a
copy of it for "training" that only has a data base password, a different
password. It was set up this way so that people training do not have to
enter a user id and password.

When a design change is made to the real data base, I currently export the
object from the real data base to the training data base and click
"replace" in the training data base. This also works but requires a lot
of "management" to be sure that they are in sync. Is there a way to copy
the entire "real" data base to the "training" data base, since they have
different levels of security?

Thanks for your ideas,
Bill

Hi Bill.

Is you app split? If it is (and it should be if you have multi-users) then
have your training front end be identical to your "real" one except map the
linked tables to a dummy back end. If you have a lot of tables you could
use code behind a command button to re-map automatically.

HTH - Keith.
www.keithwilby.com