473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access & Security

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]

MSysGroupMembers
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

MSysUserMeberships
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. . .
..
Nov 13 '05 #1
3 2101
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
Nov 13 '05 #2
wh***********@hotmail.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
Nov 13 '05 #3
> 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
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: lobrys | last post by:
hi I build a VB .NET application that makes file access, environnemet acess, database access, etc.... If I ran the app locally, everything works....(normal) If I copy the app on a server, and...
5
by: MLH | last post by:
With Access 2.0, it was simple. 97 doesn't seem so obvious. Where do I start. I launched c:\windows\system32\Wrkgadm.exe and joined system.mdw in that same dir. Upon launching Access 97, I...
1
by: Struggling Coder | last post by:
We have a database here at work and the person who created has been gone for two years. The original project manager wants to use this database on his New project, but the database is secured. I...
8
by: Tim Marshall | last post by:
I have a problem in that users can't seem to access menu bars created by a developer in the admins group. Details are as follows: I'm following the MS Access Secirty FAQ version 2.41 and I can't...
12
by: PMA | last post by:
Hi all, I am porting a web application from IE 6.0 to FireFox 1.5. I have solved almost all compatibility issues (quite a lot but not too bad) except two of them : 1) Clipboard access thru'...
2
by: Dorei-Pry | last post by:
Dear All! I have try to get all data of one MS ACCESS from one application building with .NET. But when i have open that MS ACCESS i can not see any TABLES when ever that file is 100MB of...
2
by: mbsevans | last post by:
New user here. I have constructed a database to track basic employee information. I wish to place finished database on a the network. I need to obviously retain full admin persmissions for all...
0
by: Tony Toews [MVP] | last post by:
Folks To make a long story short Office 2000 security patches are *not* included in the Microsoft Update. Although you can find them in the rather unobtrusive Office Update. For an...
1
by: Prasu TKP | last post by:
I have developed an Access Application and given to the pople to work through 'Share folder'. There are six people using every day. I have disabled the byepass key also. Very recently one peson...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.