Access & Security

[Mike Marriott]

Hello all,

Newbie Here (please go easy, you cant make me fell more stupid than I
allready do)

I have a small, but complex data base, in Access 2000, that I am
creating, I have allready starting to add data to it. Alot of data
(around 30 hours work, creating and entering data).

I did a stupid thing, I protected the thing. . . . Using the Security
Wizard, It did not ask me for any password when I was running through
it (i am actually not sure about this). But, now I cant get back into
it.

I can however get into a read-only version (limited) of Secure (the
Microsoft Access Workgroup Information[MAWI]) file using my name
"mike" and my password that I use for everything (thats why I think I
did enter a password in the Security Wizard.

There are no tables visible in the MAWI, but there are 4 Quieries,

MSysGroupList
With 1 Field (Name) and 5 Records,
Record [Admins]
Record [Full Data User]
Record [Full Permission]
Record [Read-Only User]
Record [User]

MSysGroupMember s
Asks for Group Name
Group Name
Admins Mike (only 1 record)
Full Data User (no records)
Full Permission (no records)
Read-Only User (no records)
User (no records)

MSysUserList
With 1 Field (Name) and 4 Records
Record admin
Record Creator
Record Engine
Record Mike

MSysUserMebersh ips
asks for Username
Username Name
admin Users (only 1 record)
Creator (no records)
Engine (no records)
Mike Admins (2 records)
Users
I have tried logging on to the data base with the users name of Mike,
Admin, Creator, Engine, mike, admin, creator, and engine, all with and
without the password that I would have added to the Security Wizard.

Any help would be really (um. . ) helpfull, and greatfully
appreciated. . .

Kind Regards
Mike Marriott

Feel free to ask any questions, if I have left anything vital out. . .
..

[Mike Marriott]

Futher to this, I downloaded a password recovery utility. . .
When I run this through, I have to choose if it is a Access 2000 database or
Access 97 or prior.

When I select Access 2000 (coz thats what it is), it gives me a message
saying that the database is not protected.

When I select Access 97 or prior, it shows me the first 2 charachters of the
password B".

I might see if I can purchase the program. . . . .

It is LastBit Password Tools for Access, I downloaded from;
http://lastbit.com/access/default.asp

Kind Regards
Mike Marriott

[Keith Wilby]

wh***********@h otmail.com (Mike Marriott) wrote:

I did a stupid thing, I protected the thing. . . . Using the Security
Wizard, It did not ask me for any password when I was running through
it (i am actually not sure about this). But, now I cant get back into
it.

Hi Mike.

Have you tried the user name "Admin" with no password? Other than that,
the only thing I can advise is to always work on a copy of your files and
to read and understand MS's KB article on Access security. To quote Larry
there is no filler, you need to read and understand it all. Once you've
done that you can refer to the step-by-step example on my web site (you'll
find it in there somewhere;-)).

Regards,
Keith.
www.keithwilby.org.uk

[Mike Marriott]

> Hi Mike.

Have you tried the user name "Admin" with no password? Other than that,
the only thing I can advise is to always work on a copy of your files and
to read and understand MS's KB article on Access security. To quote Larry
there is no filler, you need to read and understand it all. Once you've
done that you can refer to the step-by-step example on my web site (you'll
find it in there somewhere;-)).

Regards,
Keith.
www.keithwilby.org.uk

Thanks Kieth. . . .

I think i will heed your advised and understand something before I do it. .
..

My Computer does not like to run for any more than about 5 hours, and I had
visitors, so I rebooted, and it let me back into the back up file it made
when I ran the Security Wizard, So I have just renamed that, and I have it
all back with full permission. . . (few !)

But thank you once again for your advise. . .

Kind Regards
Mike Marriott