Help - Permissions H3ll

[LadyUK]

I have an access database I set up for a client.

The client had the program working just fine. For some reason, they had
to format the machine, and although they copied over the database, they
failed to copy over the security file with all of the permissions.

So now I cannot get into the database at all - as permissions were set
up quite strictly. I told the customer that they needed to be careful,
as I did not have a backup when I sent them the file.

Does anyone know of a way around this - any help would be greatly
appreciated.

--
Geneva
http://www.thegeneva.com
Code so clean you could eat off it

[Anthony England]

"LadyUK" <ge********@gmail.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

I have an access database I set up for a client.

The client had the program working just fine. For some reason, they had
to format the machine, and although they copied over the database, they
failed to copy over the security file with all of the permissions.

So now I cannot get into the database at all - as permissions were set
up quite strictly. I told the customer that they needed to be careful,
as I did not have a backup when I sent them the file.

Does anyone know of a way around this - any help would be greatly
appreciated.

--
Geneva
http://www.thegeneva.com
Code so clean you could eat off it

Could you re-create the workgroup? If you kept the details used to create
the workgroup, then you can re-create it. Or perhaps you use standard
details so that another mdw file you posses will have an admin account
suitable to unlock.
Failing this, just buy one of the security crackers for Access, remove all
security from the mdbs, create a new workgroup file and re-apply the
security. You could to do this and keep the cracker program for yourself,
so you now have the tools and experience to do it again.
If you need a recommendation for which one, then you can ask here, but
people here seem reluctant to advise on security crackers.

[LadyUK]

I have tried that - I have tried all password recovery softwares and
made sure there is no password on the DB - its the permissions that are
restricted.

As you can imagine, I am highly frustrated by this.

I have recreated the mdw file and linked them through a shortcut, with
no success.

I have only just learned that there is a rift between two of the
directors of the company, and I think that one of them is trying to
sabotage this for another. This is a beauty salon, and as you can
imagine, customer databases are a very very precious thing.

Thanks for the help - but if anyone else has any suggestions, please
keep them coming...

[Anthony England]

"LadyUK" <ge********@gmail.com> wrote in message
news:11*********************@v46g2000cwv.googlegro ups.com...

I have tried that - I have tried all password recovery softwares and
made sure there is no password on the DB - its the permissions that are
restricted.

As you can imagine, I am highly frustrated by this.

I have recreated the mdw file and linked them through a shortcut, with
no success.

I have only just learned that there is a rift between two of the
directors of the company, and I think that one of them is trying to
sabotage this for another. This is a beauty salon, and as you can
imagine, customer databases are a very very precious thing.

Thanks for the help - but if anyone else has any suggestions, please
keep them coming...

It is only worth re-creating the mdw file if you remember (or have written
down) the exact details you used to create it: the company name, the
username, ID, etc - see the example below.
If you don't know these details and the mdw file really has gone missing,
then you really will have to crack it. Of course, this assumes that the
other files have not been corrupted or tampered with and it is simply a
security issue. If it is only security - you can definitely break in.

Can you get them to send you the files back? (what are they mdb,mde and how
many?)
Do you know the details to re-create the workgroup?
Which programs have you tried to breal in with?
Have you got a budget, say about £100 to buy a cracker with?
******** Example Details *********
Workgroup

Filename: DbDesign_wg.mdw
Username: Peter Smith
Company: DbDesign
WorkgroupID: 846FghNaGfwKPzbCw3H

Users

No: PID: Username: Password: Full Name:
1 <ms-access created> Admin admin <none>
2 8fke3ZTRfzjPqVJSZyH Peter password Peter Smith

Groups

No: PID: Name:
1 <ms-access created> Admins
2 g4W6vA1rcFbzyDoFmKG Read-Only Users
3 MntPgQ3SXP8vpfEFK4Y Standard Users
4 <ms-access created> Users
******** End Example *********

[LadyUK]

Unfortunatly I do not have any of the details it was used to create the
database with - I am contacting one of the directors who may have the
file on a USB drive, although I suspect he won't easily cough it up -
he is leaving the company and wanting to take it with him.

I have offered to recreate a system for them using php/mysql for
future, so I can control access and set up CRON jobs to do regular
backups.

I can send you the file if you want to have a go?

[Anthony England]

"LadyUK" <ge********@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

Unfortunatly I do not have any of the details it was used to create the
database with - I am contacting one of the directors who may have the
file on a USB drive, although I suspect he won't easily cough it up -
he is leaving the company and wanting to take it with him.

I have offered to recreate a system for them using php/mysql for
future, so I can control access and set up CRON jobs to do regular
backups.

I can send you the file if you want to have a go?

If your e-mail address is real, I'll send you my details.