Locked myself out

  • Thread starter Thread starter DeMarHc
  • Start date Start date
D

DeMarHc

Hi all,

I am using Access 2002. I was experimenting with removing security as some
of my colleagues have 2007 and cannot open the database. I have no idea what
I did (I am not super at the security stuff and in hindsight I should not
have played around with security without researching it) and now I've locked
myself out. Everytime I open the database it says I don't have permission to
open it. The last thing I did was change the 'Owner' of the tables.

Is there any advice on how to recover my database?

Thanks in advance.
 
On Mon, 26 Oct 2009 14:55:01 -0700, DeMarHc

Can you restore a backup? That will be the quickest way.

-Tom.
Microsoft Access MVP
 
DeMarHc said:
Hi all,

I am using Access 2002. I was experimenting with removing security as some
of my colleagues have 2007 and cannot open the database. I have no idea
what
I did (I am not super at the security stuff and in hindsight I should not
have played around with security without researching it) and now I've
locked
myself out. Everytime I open the database it says I don't have permission
to
open it. The last thing I did was change the 'Owner' of the tables.

Is there any advice on how to recover my database?

Thanks in advance.
Click to expand...

I'm assuming you didn't back up first. You *could* try importing the
objects into a new file but I fear that you may be about to pay the price of
dabbling in security, it is *really* easy to lock yourself out. If the
import doesn't work then you may have to either start again from scratch or
purchase a crack.

If you want to learn about security there's a link to the FAQ on my web
site. You find various other useful links scattered around postings in this
NG.

Keith.
www.keithwilby.co.uk
 
On Mon, 26 Oct 2009 19:47:36 -0700, Tom van Stiphout

After reading Keith's message I have to admit I didn't think you
wouldn't have a backup. If you don't here is an idea: download, study,
and fully understand the Access Security Faq from microsoft.com. Then
use your new knowledge against yourself: you most likely did not
secure the app correctly, so you can attack that imperfection and get
back into your application.

-Tom.
Microsoft Access MVP
 
Back
Top