Re: Access 2000

Scott,

Thanks for your reply. But i have tried doing as you say and I still cannot
open the db. Their shortcut shows as “C:\ProgramFiles\Microsoft
Office\Office10\msAccess.exe” “c:\my documents\clickthis.mdb”/WRKGRP
“C:\MyDocuments\secured.mdw”

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
properties. I know their system and db logins and passwords, but never even
get to the password. Same security message as before. If I cannot get
into this db, I lose the contract. They are running XP and I am running
under W2K, but that should not make a deference other than that they do not
have the wrkgadm.exe file. Must log and change groups on XP thru system
folder. I do not know what to do next or how. Would greatly appreciate more
help.

Thanks,
Beth

"Scott McDaniel" wrote:

> The database is probably secured. You'll have to have the workgroup file
> associated with the database, as well as a valid username/password account
> (note: this is NOT a Windows account, and has nothing to do with your
> Windows permissions). The account you use will also have to have the
> necessary permissions to enable you to perform design on the database
> objects. You should be able to get this information from the same source
> that provide you with the 2000 db.
>
> If your source isn't sure of the workgroup file to provide, you can review a
> shortcut used to open the database (if there is one) ... the Target will
> sometimes tell you which workgroup is being used to open a database. If not,
> you can try running the wrkgadm.exe file (the Workgroup Administrator app)
> to determine which workgroup the machine is currently "joined" to ... you'd
> do this on a machine that can acutally open and run the database.
>
> --
> Scott McDaniel
> InfoTrakker Software
>
> "beth" <beth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:35053F77-F095-4B40-8904-001BB20B4496@xxxxxxxxxxxxxxxx
> >I have taken home an Access 2000 db to work on. But when I try to open it,
> >I
> > get the following message. "You do not have the necessary permissions to
> > use
> > the ***.mdb...". I do not even get to the screen to input a password. I
> > am
> > logged on as administrator.
> >
> > Thanks
>
>
>
.

Relevant Pages

  • Re: i give up...please tell me how to remove security
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > When I copied the database over I also copied the "secured.mdw" file and ... > shortcut that I used to open it. ... I changed the workgroup in the target of the shortcut to refer to this ...
    (microsoft.public.access.security)
  • Re: User and Workgroup was screwed
    ... We have a Access database for logging all the activities we do everyday. ... If you use a shortcut, right-click the shortcut and examine the Target property; ... Make sure the .mdw file is in the path specified. ... If you don't use a shortcut to open your db, then the machine was probably "joined" to a workgroup. ...
    (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: Neophyte question about workgroups
    ... This workgroup file is placed on your local drive at ... >> shortcut method as I cant think of it off the top of my head. ... >> read if you start securing Access database. ... >> Immanuel Sibero ...
    (microsoft.public.access.security)
  • Re: Security Question
    ... An Access database file has to be used in conjunction with a suitable ... Workgroup Information File. ... If you start the database from a shortcut, the shortcut can (but does not ... > the file all permissions through the web server folder, ...
    (microsoft.public.access.security)
Loading