Re: Access Security not secure

anonymous_at_discussions.microsoft.com
Date: 03/24/04 

Date: Wed, 24 Mar 2004 08:12:17 -0800

I created the Administrator and added him to the admin
group, removed the default admin user from the admin
group, removed all rights that the admin user has on the
database, removed all the rights from the user group.
No luck if I try to open the database from a computer that
is attached to the default workgroup I have full access to
the entire database.
I tried creating a new admin group (admin1), gave admin
rights to admin1, and removed admin rights from the admin
group still same results. Security is nonexistent if I
open the database from a computer with a fresh load of
access2000 or access2002 that has the default workgroup.
Any help would be appreciated
>-----Original Message-----
>Hi,
>
>First you'll need to create another user(eg.
Administrator) and add him to
>the admin group.(This is very important or you going to
lock yourself out of
>the db).
>
>Then you'll need to remove the default admin user from
the admin group.
>
>You can then remove all rights that the admin user has on
the database.
>
>Also try removing all the rights from the user group.
>
>Should secure your database enough.
>
>Regards,
>
>Martin.
>
>"Jerry Gaber" <Jerome.D.Gaber@boeing.com> wrote in message
>news:f4f201c41115$c903a060$a601280a@phx.gbl...
>> I have a database that was an access97 database it was
>> secure. If a user attempted to open it directly it
forced
>> a the user to join the workgroup. The database was
>> converted to access2000 then access2002 in both
instances
>> if the user has allready joined the workgroup the login
>> appears and all works as expected. however if the user
has
>> not joined the workgrout and is connected to the default
>> workgroup access is granted to the database with full
>> permissions. How do i secure the database so someone
that
>> has access to the sharred drive cannot access the
database
>> without joining the correct workgroup?
>
>
>.
>

Relevant Pages

  • Re: Access Security not secure
    ... The first step is to create a new workgroup. ... > I created the Administrator and added him to the admin ... > No luck if I try to open the database from a computer that> is attached to the default workgroup I have full access to> the entire database. ... >>Should secure your database enough. ...
    (microsoft.public.access.security)
  • Re: Access Security not secure
    ... You should secure it manually. ... > In your test with using a new workgroup and running the> wizard it was in access2000 then again in access2002 ... >>> to work well until I try to access the database on the ... >>>>> I created the Administrator and added him to the> admin ...
    (microsoft.public.access.security)
  • Re: Able to open secured database with default MDW
    ... Joan and David: I want to thank you both for your efforts to help me. ... The admin user can be in any other group in any other ... system workgroup that does have permission. ... All this and I can still get into the database directly when using ...
    (microsoft.public.access.security)
  • Re: Able to open secured database with default MDW
    ... the database when joined to Syst em.mdw. ... "Susan L" wrote: ... The admin user can be in any other group in any other ... system workgroup that does have permission. ...
    (microsoft.public.access.security)
  • Re: Sorting out security
    ... > MS Access security. ... > created a new workgroup, added a password for the Admin role, added ... > remote logins to a secured database. ... The location of the current workgroup file is recorded in the ...
    (microsoft.public.access.security)