|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Export or Import Objects from One Secured Database to AnotherIs it possible to export or import Access database objects (i.e. tables,
queries, etc) from one secured (based on the Access Security FAQ) database to another secured database which uses a different MDW file (different usernames and passwords)? I have exported between secured and unsecured databases, databases secured with the same MDW, and imported from an unsecured into a secured. Don Yes it is, provided you create the same username/PID in each mdw, and that
user or the groups to which they belong have permission. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Don wrote: > Is it possible to export or import Access database objects (i.e. > tables, queries, etc) from one secured (based on the Access Security > FAQ) database to another secured database which uses a different MDW > file (different usernames and passwords)? I have exported between > secured and unsecured databases, databases secured with the same MDW, > and imported from an unsecured into a secured. > > Don Joan,
Just to be sure I understand your answer, let me expound a little. If I add a new user to each workgroup (same username and PID), I could then use that username to accomplish the transfers. This even though the Work Groups themselves are totally different (i.e. one is not derived from the other). Basically, it is the username/PID in the work group that is used to access the database. Thanks for the response! Don Show quoteHide quote "Joan Wild" <jwild@nospamtyenet.com> wrote in message news:e30Uffb1FHA.1040@TK2MSFTNGP14.phx.gbl... > Yes it is, provided you create the same username/PID in each mdw, and that > user or the groups to which they belong have permission. > > -- > Joan Wild > Microsoft Access MVP > > Don wrote: >> Is it possible to export or import Access database objects (i.e. >> tables, queries, etc) from one secured (based on the Access Security >> FAQ) database to another secured database which uses a different MDW >> file (different usernames and passwords)? I have exported between >> secured and unsecured databases, databases secured with the same MDW, >> and imported from an unsecured into a secured. >> >> Don > > Yes, you have it right. It wouldn't matter which workgroup file they used,
either. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Don wrote: > Joan, > > Just to be sure I understand your answer, let me expound a little. If I > add a new user to each workgroup (same username and PID), I > could then use that username to accomplish the transfers. This even > though the Work Groups themselves are totally different (i.e. one is > not derived from the other). Basically, it is the username/PID in the > work group that is used to access the database. > > Thanks for the response! > > Don > > > > > > > "Joan Wild" <jwild@nospamtyenet.com> wrote in message > news:e30Uffb1FHA.1040@TK2MSFTNGP14.phx.gbl... >> Yes it is, provided you create the same username/PID in each mdw, >> and that user or the groups to which they belong have permission. >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Don wrote: >>> Is it possible to export or import Access database objects (i.e. >>> tables, queries, etc) from one secured (based on the Access Security >>> FAQ) database to another secured database which uses a different MDW >>> file (different usernames and passwords)? I have exported between >>> secured and unsecured databases, databases secured with the same >>> MDW, and imported from an unsecured into a secured. >>> >>> Don Joan,
Very interesting indeed! Thanks! Don Show quoteHide quote "Joan Wild" <jwild@nospamtyenet.com> wrote in message news:uV4Opzb1FHA.664@tk2msftngp13.phx.gbl... > Yes, you have it right. It wouldn't matter which workgroup file they > used, either. > > -- > Joan Wild > Microsoft Access MVP > > Don wrote: >> Joan, >> >> Just to be sure I understand your answer, let me expound a little. If I >> add a new user to each workgroup (same username and PID), I >> could then use that username to accomplish the transfers. This even >> though the Work Groups themselves are totally different (i.e. one is >> not derived from the other). Basically, it is the username/PID in the >> work group that is used to access the database. >> >> Thanks for the response! >> >> Don >> >> >> >> >> >> >> "Joan Wild" <jwild@nospamtyenet.com> wrote in message >> news:e30Uffb1FHA.1040@TK2MSFTNGP14.phx.gbl... >>> Yes it is, provided you create the same username/PID in each mdw, >>> and that user or the groups to which they belong have permission. >>> >>> -- >>> Joan Wild >>> Microsoft Access MVP >>> >>> Don wrote: >>>> Is it possible to export or import Access database objects (i.e. >>>> tables, queries, etc) from one secured (based on the Access Security >>>> FAQ) database to another secured database which uses a different MDW >>>> file (different usernames and passwords)? I have exported between >>>> secured and unsecured databases, databases secured with the same >>>> MDW, and imported from an unsecured into a secured. >>>> >>>> Don > > > If I add This appears not to be so for modules. They appear to require the "owner", and> a new user to each workgroup (same username and PID), I could then use that > username to accomplish the transfers. > of course the "owner" is not visible for modules. Chris 
Other interesting topics
Share Workgroup Information File
Access Security When called from .NET You do not have Exclusive acces to the database at this time????? Database on network , but if 1 user logs in others are locked out Access 2000 Security Object Documenting, please help! got Error 3045, sounds like a problem with workgroup file Re: Overall Security??? Can't create new forms Overall error security at data level.. |
|||||||||||||||||||||||
