Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Re: security affecting all databases

Discussion in 'Information Technology' started by Jake, Jul 28, 2006.

  1. Jake

    Expand Collapse

    I am having the same problem where everything requires a log-in. I tried
    finding where to re-join, but I can find it and I tried deleting my
    secured.mdw and opening it, but it just said it was invaild. Can you help me
    out?? I spent too much time programing SQL and VB too loose it over Security.


    "Rick Brandt" wrote:

    > Shar wrote:
    > > I have created a database to be used only by 3 departments in my
    > > company. We have never used security before on any of the databases
    > > since they were not being used in a multiuser environment. We have
    > > Access 2000 and I have used the security wizard to create a new
    > > workgroup and setup group and user accounts and permissions. I have
    > > created a shortcut to my desktop using the "C:\Program
    > > Files\Microsoft Office\Office\MSACCESS.EXE" ...mdb" /WRKGRP
    > > ...Secured.mdw" to be used only with that database. I thought I had
    > > everything working as I would like with that database but I am now
    > > needing to login each time I open other databases that have not been
    > > secured. I have found in my search somehow my default system.mdw in
    > > the registry has changed to reflect the security I had setup for my
    > > secure database. I am perplexed as to how this happened since I used
    > > the wizard and now what to do about it. Is there any way to restore
    > > the default workgroup without having to de-secure my other database?
    > > Also, I wanted to create an mde after having this worked out --
    > > anything I should be aware of?

    > What has probably happened is that Secured.mdw has been made your default
    > workgroup. Just go into the Workgroup Administrator utility and "re-join"
    > the default workgroup (system.mdw).
    > If you really discover that System.MDW is asking for a login prompt try
    > renaming it and then launch Access without specifying a file to open. In
    > versions 2000 and higher Access will automatically create a new System.mdw
    > if it can't find it. If that works then the renamed one can be safely
    > deleted.
    > --
    > I don't check the Email account attached
    > to this message. Send instead to...
    > RBrandt at Hunter dot com
  2. Loading...

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page