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 - 27 Jul 2006 16:07 GMT
>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
[quoted text clipped - 11 lines]
> 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