RE: cant open database

Ok sorry guys i just figured it out!!! use the workgroup administrator to
point to the workgroup info file and its all working now!

"DowningDevelopments" wrote:

> IM sure you get this all the time but...
>
> yesterday i was working on another PC where i went throug the steps to setup
> User Level security, it seemed to work, though i didnt check it for other
> users, i was prompted for my password everytime i opened the database on that
> computer. I even printed out the one step security wizard Report (which is
> where i get most of my information).
>
> This morning i am on a different comptuer but as the database is on the
> network im assuming that i can open it and put in my password, i cant!!
> Instead i get the following message:
>
> You do not have the necessary permissions to use the
> 'H:\Data\Access\test1.mdb' object. Have your system administrator or the
> person who created this object establish the appropriate permissions for you'
>
> and when i click ok i get a blank screen, Thanksfully thats the backup so iv
> still got all my information but how can i open it??
> I am the administrator!!
>
> It is telling me that the Workgroup information file is at
> H:\Data\access\Security.mdw
>
> I think i need to point the access to this file on each computer so that it
> knows where the user information is kept, how might i do this or what else do
> i need to do??
>
> With much thanks,
>
> Amit
.

Relevant Pages

  • Re: Access 2000
    ... I have created and then logged in under the workgroup WRKGRP on my system, ... copied their secured.mdw file to my system, and given my shortcut the same ... > The database is probably secured. ... "You do not have the necessary permissions to ...
    (microsoft.public.access.security)
  • Re: Access 2002/2003 You dont have the necessary permissions...
    ... Re. the message "You do not have the necessary permissions to use the ... - If the database HAS NOT been secured: ... It's nothing to do with the macro security level. ... relevant PCs to the relevant workgroup information file, ...
    (microsoft.public.access.security)
  • Re: Locked out of dbase ATTN: RICK
    ... access to the database, ... >> would creating the new workgroup automatically give me administrative ... Once to give administrative rights to the person I'm ... >> If you open the workgroup administrator, you can see which one you are ...
    (microsoft.public.access.security)
  • Re: Permission changes from computer to computer
    ... Assuming your database is the only one they will use, ... Do I (as administrator) set this up for all the users or do they have to do ... "Rick B" wrote: ... > workgroup in which you created your passwords. ...
    (microsoft.public.access.security)
  • Re: Domain and Workgroup problem
    ... If the workstation is joined to the domain; and you are logging onto the ... Access this computer from the network right. ... The person who administered it added a workgroup. ... > logons--both as administrator (not as AN administrator but as THE ...
    (microsoft.public.win2000.networking)