Re: Help - locked out of database

Tech-Archive recommends: Fix windows errors by optimizing your registry

When you modified the shortcut target, did you also change the path to the mdb (as well as the mdw)?

--
Joan Wild
Microsoft Access MVP
"Litespeed" <Litespeed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3EF08481-B044-45C8-ACFF-C7B9316EE363@xxxxxxxxxxxxxxxx
Hi Joan,

IT originally moved the folder that contains all my files on the network -
they embedded it in another folder (not sure why). Because they did that my
shortcut no longer worked. I went in to the properties of the shortcut just
like you mentioned below and tried to redirect it but it didn't work. IT
has, at my request, moved the folder back to its original location, but I
think when I was trying to redirect the shortcut I messed something up.

I just double checked the properties of my shortcut file (target and start
in) and they both look fine.

I have a folder on the network that contains my database.mdb file, my
databasebackup.mdb file and my secured.mdw file. I can access the mdw file
but nothing else.

I'm confused :)

Litespeed





"Joan Wild" wrote:

"Litespeed" <Litespeed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AB3237F4-ADC7-4E95-9E16-469E4E761D7E@xxxxxxxxxxxxxxxx

The database has 3 users - "admin", "myself" and "planner"

I belong to the Admins user group as well as the users group.
"admin" and "planner" belong to the users group.

Usually when I log in I have to enter a password, as does "planner".
However when I try to open my database know I get the message that I do not
have the necessary permissions...etc. I have always opened the database from
a shortcut on my desktop. Last week our IT did some fiddling around with
files and know it doesn't work. I have tried to open the .mdb file directly
from it's location and I get the same message.

That's a good sign, as in this case you are trying to open the mdb using system.mdw, and you shouldn't be able to open the mdb.

IT should be able to be clearer than' fiddling around with files'; did they move them? If so, where are they.

If you can't get help from them, try doing a search for the secure mdw. It's likely that this file has been moved. You'll need to modify your desktop shortcut to point to the new location of the secure mdw. Right-click the shortcut and choose properties and look at the target line. It'll have the following in it:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"


--
Joan Wild
Microsoft Access MVP

.

Relevant Pages

  • Re: workgroup information file (WIF) problem
    ... Microsoft Access MVP ... Can you point me to a reference which explains how to manually split ... "Joan Wild" wrote: ... Copying the shortcut to each user's PC will work, ...
    (microsoft.public.access.security)
  • Re: Security files
    ... In the shortcut target the "path to mdb" would be the path to the frontend on each user's computer. ... Microsoft Access MVP ... "Joan Wild" wrote: ... If you find that the Open permission is already set, post the contents of the target of your shortcut. ...
    (microsoft.public.access.security)
  • Re: Help - locked out of database
    ... I have checked the shortcut at my other ... "Joan Wild" wrote: ... Microsoft Access MVP ... It's possible that you don't have enough Windows permission on this new folder. ...
    (microsoft.public.access.security)
  • Re: Lost Permission
    ... that means that the password for the 'Admin' user has been set to ... Close Access and try your shortcut again, ... > "Joan Wild" wrote: ... >> Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Security setup, completely lost
    ... Try and copy the shortcut you have on your desktop to the other user's desktop and see if it works. ... Microsoft Access MVP ... "Joan Wild" wrote: ... There is always *some* mdw file set as the default to use. ...
    (microsoft.public.access.security)