Re: how due I unsecure a database
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Fri, 24 Aug 2007 20:37:50 GMT
babs wrote:
I have a database that I setup security that it prompts for user id
and password. I would like to turn off that feature so that anyone
can go in and modify the database - we no longer have a need for
turning on the security.
How do I get rid of the prompting for user name and allow people to
get in and modify with out that.
Thanks,
Barb
Open and login as a user with administrative rights. Once in give full
permissions on all objects to the group "Users". That's pretty much it, but
if you wanted to be a bit more thourough you could then close Access and
then open it with the default workgroup (one that does not ask you to log
in). Then create a new blank file and import into it all of the objects
from your existing file. That should work after giving "Users" permissions
to everything. That will make "Admin" the owner of all objects which is the
case on a file that was never secured in the first place.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- Prev by Date: Re: copy secure database onto a network
- Next by Date: Re: Hidden Tables
- Previous by thread: Re: HELP!
- Next by thread: Re: Hidden Tables
- Index(es):
Relevant Pages
|
