Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2006
    Posts
    2

    Unanswered: About to throw up - Please Help - Security question

    Short & sweet

    Had user level security on a database. All of the security files have been deleted. The *.bak, *.mdw, & *.snp. When attempting to open the database I get the "You do not have the necessary permissions to use the '***' object, blah blah blah." error message.

    Please, please tell me there is a work around or some way to get back in the db. I feel like I swallowed a frog. Can someone please help me?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    so, if you were to open access as the admin, and create a new db and import everything from the crippled one, that wouldn't do it?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2006
    Posts
    2
    No, I get the same "You do not have the necessary permissions" error

  4. #4
    Join Date
    Nov 2004
    Location
    Harrogate, N.Yorks, UK
    Posts
    83
    Was the database on a server? Have admin got a server backup? Also, have you checked recycle bins?
    Last edited by jonesyfella; 12-04-06 at 05:48.

  5. #5
    Join Date
    Mar 2004
    Location
    UK
    Posts
    82
    how do we know its your db app you're trying to get into
    Last edited by "L"PLATE; 12-04-06 at 07:35.

  6. #6
    Join Date
    Jul 2006
    Posts
    108
    I agree, from what he's telling me this is a hacking procedure gone bad...

  7. #7
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by jwalker343
    I agree, from what he's telling me this is a hacking procedure gone bad...
    Either that, or someone was hacked off when leaving and decided to do one last "favor" for the company ...

    This is why I was saying that using the system.mdw AND opening a new db and copying over everything should work ... Minder: using system.mdw (without mods) sets you as the Admin for the entire machine ...
    Back to Access ... ADO is not the way to go for speed ...

  8. #8
    Join Date
    Mar 2004
    Location
    UK
    Posts
    82
    if it's his db, i don't think he should have too much trouble getting in to it..

  9. #9
    Join Date
    Nov 2004
    Location
    Harrogate, N.Yorks, UK
    Posts
    83
    There's nothing like being left in suspense anyway!

  10. #10
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Maybe that frog actually got caught in his throat! I suspect our more skeptical thoughts were too close to the mark and he's gone elsewhere. I noticed at the time of the original post that he'd only joined this month!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •