Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / July 2006

Tip: Looking for answers? Try searching our database.

Two DataBases, One Secure and One Not

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
B F Cole - 27 Jul 2006 15:47 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 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.