Re: Help - locked out of database

Okay - now I am seriously worried. I have checked the shortcut at my other
office and it no longer works.

I have poured a year into this database - is there someway to recover this?
I can't even access my backup.

Seriously concerned litespeed.

"Litespeed" wrote:

dang...I was sure I could get in on a planner computer-I can't. I actually
work at two separate offices and on Friday (after all the moving around of
the folders) I could open the database at my other office. I first
discovered the problem when I was at the office I am at today and it is from
this location I was playing around with targets and such. (I hope this is
making sense!)

I think I am going to have to stop at my other office on the way home and
see if it is working, and if it is I will make a note of the target. It
doesn't make sense though as I access the same V"\ drive at both locations -
only the shortcut is different. It is really confusing as well because I
never touched the shortcut on the planner computer and it is not working
either :( Shouldn't that indicate that something has changed in the mdw or
mdb file?

Litespeed

"Joan Wild" wrote:

It sounds as though something is wrong with the target of your shortcut. If it works on the planner's computer, double check - what's different about their shortcut?

--
Joan Wild
Microsoft Access MVP
"Litespeed" <Litespeed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:61EC6D48-BA26-4246-A9AA-054569831FA2@xxxxxxxxxxxxxxxx
No - I just checked and my permissions haven't changed :(

I can open the .mdw file - is that any help?

Or I think I can log into the database from one of the planners
computers...if I just knew what to do :)

Litespeed

"Joan Wild" wrote:

Perhaps it's a Windows permission error and not Access at all.

You need, at minimum, modify permission on the folder. It's possible that you don't have enough Windows permission on this new folder.

--
Joan Wild
Microsoft Access MVP
"Litespeed" <Litespeed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2D0AC0CE-E905-431C-8989-EE290BD3E229@xxxxxxxxxxxxxxxx
Hi Joan,

Yes I did - the target is below:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"V:\PLN_Planning\PROJECTS\ACCESS-PROJECT DATABASE\ProjectDatabase.mdb"
/WRKGRP "V:\PLN_Planning\PROJECTS\ACCESS-PROJECT DATABASE\Secured.mdw"

It looks fine to me as the mdw and mdb are in the same folder.

Below the target, the "start in:" path is:
"V:\PLN_Planning\PROJECTS\ACCESS-PROJECT DATABASE\"

Which with my limited expertise looks fine as well....

litespeed


"Joan Wild" wrote:

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: Help - locked out of database
    ... dang...I was sure I could get in on a planner computer-I can't. ... only the shortcut is different. ... "Joan Wild" wrote: ... It's possible that you don't have enough Windows permission on this new folder. ...
    (microsoft.public.access.security)
  • Re: Help - locked out of database
    ... both the mdw and mdb still exist. ... "Joan Wild" wrote: ... Microsoft Access MVP ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • 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: Help - locked out of database
    ... It sounds as though something is wrong with the target of your shortcut. ... Microsoft Access MVP ... "Joan Wild" wrote: ... It's possible that you don't have enough Windows permission on this new folder. ...
    (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)
Loading