Locked out of database

[litespeed]

It seems that I am locked out of my database. I am not an advanced ACCESS
user but did develop a fairly decent database that meets the needs of my job.
I set up security at the beginning when I really didn't know very much.

Here is what I can tell you;

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 now I get the message that I do not
have the necessary permissions...e tc. I have always opened the database from
a shortcut on my desktop. Last week our IT did some fiddling around with
the folders on the network, and I tried to redirect the shortcut. The folders have been back in their original location but now I can't open the database using the shortcut. I have tried to open the .mdb file directly from it's location and I get the same message.

My whole life is wrapped up in this database - any ideas. Obviously I have
some security problems - how can I fix this??

Any help appreciated.

Litespeed

[missinglinq]

See if this helps:

How to Unsecure a Secure Access Database

Welcome to TheScripts!

Linq ;0)>

[NeoPa]

With that history, the first thing I'd do is to make a copy of the db onto your C: drive (somewhere you have full access to of course) and see if you still have the problems. If so it is within your db :( If not, then it's a network issue and you need some help from your IT people.

[litespeed]

See if this helps:

How to Unsecure a Secure Access Database

Welcome to TheScripts!

Linq ;0)>

I'm totally locked out - if I'm not mistaken I would have to be in my mdb to unsecure? Did I miss something?

Litespeed

[litespeed]

With that history, the first thing I'd do is to make a copy of the db onto your C: drive (somewhere you have full access to of course) and see if you still have the problems. If so it is within your db :( If not, then it's a network issue and you need some help from your IT people.

Well I tried that - still didn't work. We had several power outages over the weekend and I'm wondering if perhaps my file is corrupt now - it is just not making any sense :)

Litespeed

[NeoPa]

I'm totally locked out - if I'm not mistaken I would have to be in my mdb to unsecure? Did I miss something?

Litespeed

Yes.
Please read it again carefully. If you have questions on it please feel free to post them.
BTW. "I don't understand - please tell it all to me again in words I don't have to concentrate on." is not a question.

[litespeed]

Yes.
Please read it again carefully. If you have questions on it please feel free to post them.
BTW. "I don't understand - please tell it all to me again in words I don't have to concentrate on." is not a question.

"BTW. "I don't understand - please tell it all to me again in words I don't have to concentrate on." is not a question " Excuse me???

That is not what I was implying - I followed your link - presuming that I was to follow the steps indicated. ie Step 1) Log on as a member of the admins group. I cannot do this - nobody can log into the db - we are all getting the message that we do not have the necessary permissions. I am the administrator and I can't get in either - hence my confusion on how to move to step 2 if I can't accomplish step 1. There is no option to log in.

On looking again perhaps I was to skip to the 2nd post in the string. Perhaps you could of pointed that out with out implying I was being lazy. I have spent 24 hours trying to figure this out on my own, have read countless articles and am learning as I go. I'm sorry if my comprehension of the program is well below your superior level - but implying I don't want to concentrate is simply unacceptable.

[NeoPa]

Please don't be so quickly on the defensive.
I was neither accusing you of being lazy nor trying to imply you were stupid for not "getting" what was posted.
I was simply responding very directly to your question. I made no assumptions about why you didn't follow (get) the link.

Unfortunately though, I'm getting quite experienced at responding to posters and I find so often that a post of the type I indicated is an all too frequent response to the request for posting a question if there is something they don't understand. My last sentence was simply put there to head that off before it had a chance to arise. It was not intended to insult you. I really don't make judgements about individual posters quite as quickly as that.

BTW. Logging in to the database is actually logging in to Access. You will need a database but not necessarily the problem one, just to trigger the login. Try logging in to another database. This will give you the rights you need within Access, from where you can manage the security system (actually stored in a System.Mdw file). Step 2 will require the actual database open mind you.

Question for you - Have you disabled the Admin account in any way from the original (for your database or generally)?

[Jim Doherty]

It seems that I am locked out of my database. I am not an advanced ACCESS
user but did develop a fairly decent database that meets the needs of my job.
I set up security at the beginning when I really didn't know very much.

Here is what I can tell you;

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 now I get the message that I do not
have the necessary permissions...e tc. I have always opened the database from
a shortcut on my desktop. Last week our IT did some fiddling around with
the folders on the network, and I tried to redirect the shortcut. The folders have been back in their original location but now I can't open the database using the shortcut. I have tried to open the .mdb file directly from it's location and I get the same message.

My whole life is wrapped up in this database - any ideas. Obviously I have
some security problems - how can I fix this??

Any help appreciated.

Litespeed

My guess is your answer will lie in the 'fiddling around with the folders on the network' bit.

The original setup worked so - process of elimination... where was the original mdb in other words the full path. In addition to this the secure aspect of working with the database via your shortcut relied on working with the .MDW file that controlled the user accounts and permissions. What was the full path to that and where is it now.

Copying the DB to your deskstop or C drive I dare say wont work because my 'guess' is your client installation of Access is defaulting to working with the current clients SYSTEM.MDW file whereas your shortcut had the full command line to support a connection to the database along with the full path to the relevant MDW file that the mdb file was hitherto working with.

To post the full command line string that your shortcut (the target) uses namely the one that worked at the time may well help in sorting this one out or at least assist in determining where to target. If your IT guys replaced that shortcut 'in the fiddling process' they might not fully understand command lines in Access and might have replaced it with a simple shortcut to open the database as is. in which case in would certainly not work like I say if your default installation of Access is working under the clients System.MDW file.

So knowing your 'current' shortcut target path statement might help if you post it

Regards

Jim :)