Locked myself out

[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.

 

[Tom van Stiphout]

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

 

[Keith Wilby]

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.

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

 

[Tom van Stiphout]

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