Locked myself out

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

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
 
K

Keith Wilby

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
 
T

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
 
J

J_Goddard via AccessMonster.com

Hi -

If when you created the users in your .mdw file you did as Microsoft suggests
and recorded the exact Username AND the Personal ID (Case Sensitive) of each
user, you can try recreating the .mdw file (back up the old one first!!),
using the EXACT SAME User Name / Personal ID combinations for each user, and
then assign the proper permissions. Then try opening the database with the
new .mdw file.

Might work -

HTH

John
 
Top