Re: User access on a company intranet

They are still using the shortcut I placed in our department folder when I
created the database before I used the security wizard and it the same one I
use to open the database. Also, it is the only icon in the folder. However
when I open the database I get the prompt to enter my user name and password.
I can also enter other users names and password on my computer and enter as
the database as them. In fact it showes them as current user when I go to
the User/Permission drop down in Security and me as the owner of the
database. However, when I do this on their computer it goes stright into the
database.

All users are using the same icon to enter the database. How do I creat a
new shortcut? Do I get rid of the orginal Icon and replace it with an icon
that take them to my Secured1 database?

When I said below that I was asked to join what I meant was that I went into
Workgroup Admin and join the Secured1 file that was created.

"Joan Wild" wrote:


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: Security Wizard Locked ALL Dbs
    ... Username/Password for any access database I try to open ... I just want all of this security off ... Make a shortcut to your mdb file: ... Place the cursor at the far left of the Target ...
    (microsoft.public.access.security)
  • Re: Access db accessibility (permissions??)
    ... if you have not then your computers are workgrouped, security becomes a bit ... password when you first login to your database. ... > folder and then delete it. ... So the permissions are RWED on that folder. ...
    (microsoft.public.access.security)
  • Copy FE of DB when it is already open on the server
    ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
    (comp.databases.ms-access)
  • Re: secured database with Access 2002 or greater on network
    ... Not sure what the /wrkgrp goes with the database or the security ... Path of database located on F: ... you'll need to modify the shortcut so that the path to Access reflects ... in the same folder as the mdb. ...
    (microsoft.public.access.security)
  • Re: Multi user enviroment - part II
    ... Let's say for the sake of discussion that I have a multi-user database ... Give the new security file an ID, note the User, Organization, and ID ... MyAppFolder with the workgroup information file used when establishing ... "You can create a shortcut and enter this syntax as the target of the ...
    (comp.databases.ms-access)