Re: access

From: frank (anonymous_at_discussions.microsoft.com)
Date: 04/29/04


Date: Thu, 29 Apr 2004 16:48:46 -0700

I copy the mdw to the server now it promp for user name
and password. I enter user name with admin right but only
one form could be open which I assign to user right.
I could not log on to user account also.
>-----Original Message-----
>frank wrote:
>> I create a database (table, form..) and set security for
>> user. I save it locally and test the security permition
>> it seems ok. I copy the data file to network and open
it
>> from network. When I open it which no longer ask for
user
>> name and password and directly open it but when I click
>> form or table, I do not have admin access. Any one
please
>> help!
>
>That suggests that the Users Group still has open
permission on the database
>object. You shouldn't be able to even open the mdb
without using the
>correct workgroup file. You'll need to copy the mdw to
the server, and give
>users a shortcut to open the mdb. First correct the
problem with the Users
>Group.
>
>The shortcut would look like
>"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>.
>



Relevant Pages

  • Re: Security not clicking
    ... You do not create a shortcut on the network. ... Copy the backend to the server. ... Copy the secure mdw to the server. ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... have the permissions set correctly. ... who also had admin rights when I created the secured database. ... Close Access and try your shortcut again. ... I have an MDW file of the same name as the MDB, ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... Set a password for the Admin user (remember that the ... Close Access and try your shortcut again. ... I have an MDW file of the same name as the MDB, ... Use a desktop shortcut to launch your secure mdb. ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... Changed the password for admin, but then get the same message that I ... Close Access and try your shortcut again. ... I have an MDW file of the same name as the MDB, ... Use a desktop shortcut to launch your secure mdb. ...
    (microsoft.public.access.security)
  • moving a mdw file - 2
    ... I moved the file MDW from one server to another. ... updated the shortcut command line to read the new server. ... The intial shortcut target command line was: ...
    (microsoft.public.access.security)

Loading