Two DataBases, One Secure and One Not

27 Jul 2006 2:47 PM

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

27 Jul 2006 3:07 PM

Keith Wilby

Show quote Hide quote

"B F Cole" <bfc***@ipass.net> wrote in message
news:zm4yg.25848$so3.11202@southeast.rr.com...
>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