Re: more than one db -one without security one with security
- From: "Rick B" <Anonymous>
- Date: Wed, 31 Aug 2005 10:39:36 -0500
You do not need to join your secure.mdw if the shortcut includes it.
--
Rick B
"Sher" <Sher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D353373-642D-452F-AD23-8ED0A864EDB0@xxxxxxxxxxxxxxxx
> Hi Rick,
> Ok this is the way I understand it.
> A new office 2003 install defaults to the system.mdw (or if an old install
> join user to it.)
> Then setup secure icon pointing to the secure mdw and use it instead of
> doing a join to it. Does pointing to it in the icon do the same thing as
a
> join or do I have to join it first?
> thanks for all your help on this.
> Sher
>
>
> "Rick B" wrote:
>
> > If they use your shortcut, then that tells Access to use the secure MDW
only
> > for that session. Next time they open a database it will use whatever
they
> > are joined to. Go back and join all your users to the default
workgroup.
> > That is the one that will be used if nothing special is done when
opening
> > Access.
> >
> > Hope that makes sense. Post back if not.
> >
> > --
> > Rick B
> >
> >
> >
> > "Sher" <Sher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:7A27D1D6-9282-4F07-82CB-5CA8E1F0A62E@xxxxxxxxxxxxxxxx
> > > Hi Rick,
> > > Once I have joined the user to the secure database then I need to then
> > > rejoin that user to the system.mdw? or are you saying that everytime
the
> > user
> > > needs to use another database he needs to join the system.mdw each
time?
> > > I have an icon setup for the secure database with the path to the
> > secure.mdw.
> > > I'm not understanding how the join works. Is it that once joined (to
the
> > > secure db) that it keeps that setting even if you rejoin to the
> > system.mdw?
> > > So the user can actually still connect to the secure db with the
security
> > in
> > > tact?
> > > Thanks in advance for your help.
> > > Sher
> > >
> > > "Rick B" wrote:
> > >
> > > > The short answer is that the user would use your workgroup file when
> > opening
> > > > your secured database. You can create a shortcut for your database
that
> > > > includes the path to your workgroup file.
> > > >
> > > > When you open access for any other purpose, they should use their
> > default
> > > > system.mdw workgroup which would not contain any password or
privilege
> > data.
> > > >
> > > >
> > > >
> > > > --
> > > > Rick B
> > > >
> > > >
> > > >
> > > > "Sher" <Sher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > news:92FE1641-430C-4723-858C-C163275D4E2A@xxxxxxxxxxxxxxxx
> > > > > I forgot to mention that the reason I want to be able to create a
> > database
> > > > > without security.
> > > > > Example: shared secure database on my server for user1
> > > > > now user1 wants to create his own db on his workstation without
any
> > > > security
> > > > > and will only be used by him. He actually wants to create more
than
> > one
> > > > but
> > > > > he also has to be joined to the one on the server.
> > > > >
> > > > > "Sher" wrote:
> > > > >
> > > > > > Hi all,
> > > > > > Can someone tell me how access is suppose to handle more than
one
> > > > database.
> > > > > > Example:
> > > > > > old 97access database with security set
> > > > > > updated machine to office 2003 access and will convert database
> > > > > > My problem:
> > > > > > joined secure database
> > > > > > now when I create a new database it takes on the security of the
> > joined
> > > > > > database.
> > > > > > I want to be able to have a second database or even third
database
> > that
> > > > does
> > > > > > not use security.
> > > > > > My secure database is on a shared folder on the server and .mdw
is
> > in
> > > > that
> > > > > > folder.
> > > > > > I created a second db on my workstation and isaved my id.mdw to
my
> > > > documents
> > > > > > and settings under access.
> > > > > > how can I stop it from looking at the joined database security?
> > > > > > Thanks for any help
> > > > > > Sher
> > > >
> > > >
> > > >
> >
> >
> >
.
- Next by Date: Getting into Admin.
- Next by thread: Re: more than one db -one without security one with security
- Index(es):
Relevant Pages
|
