Re: User access on a company intranet


Dan wrote:
It still does not work. Most can still access the database without
any prompt then what I have set up within my database. Others gets a
message that they do not have permission and for them to contact the
admin. How do I give them permission. I have given them a user name
and password that I set up in the Security Wizard, but they can not
get to the prompt to use it

The ones getting the 'no permission' message tells me they either don't have
permission to open the db (not likely), or they aren't using the correct mdw
file.

Have you given them a desktop shortcut with the following in the target?:

"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to mdw"

The path to mdw would be the path to the mdw you used to secure it with.

If this is a problem my database is set up on a server and the
database is in a folder only people in my department can access. Is
there any way to turn off the security function in Access?

If you rename the bak file to have a mdb extension, that file will be
unsecured. You may have to rejoin system.mdw on your computer though. When
you created the new mdw, it likely made it the default one to use for all
sessions. Go to Tools, security, workgroup administrator and click on Join
and rejoin system.mdw (you should search for it first).

When I first set this up I gave each user in my department a user name
(jsmith) however this may be different then the user name they have
on the network.

That's fine.

I also gave each a unique password and added their
user name and password to my security settings in the wizard.

That's fine.

After
doing this when I first went in I was asked to join the Secured1
database, but no one else was asked this.

'Asked to join'? What do you mean? What was the exact message?


--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: User access on a company intranet
    ... All users need full permission on the folder where the mdb is located. ... You wouldn't need to do this in your copy of the database. ... then the only way to open the secure mdb is by using the mdw you ...
    (microsoft.public.access.security)
  • Re: distribution and security
    ... one mdw and from inside of access with the default mdw. ... permission of the user. ... not still listed as the owner of the database object. ... Owners haves rights even ...
    (microsoft.public.access.security)
  • no read permission on MSysObjects of MDW
    ... Each time I run the user-level security wizard to create an mdw for my ... Once I have run the wizard, I close the database and open the .mdw file I ... no read permission on 'MSysObjects' ...
    (comp.databases.ms-access)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)