User and Workgroup was screwed

23 Jul 2006 6:38 AM

Aki

Hi
We have a Access database for logging all the activities we do everyday. It
was oreginally created and designed by one of my co-workers. Just about few
days ago, he tried to add a person onto the user list for giving permission
to edit some of the tables. However, somehow the whole system was screwed
and now it won't let us in and shows message says that we don't have the
administrative right. It now doesn't shows up any login window. We have
done anything we can do tried to fix the problem, even replace the .mdw
file, but still no luck.

Is there anyone can tell me what we can do to make the database to bypass or
remove the security setting? We've lost 19 days worth of log. It will be
appreciated if any one of you can help us with this trouble. Thanks.

23 Jul 2006 11:59 AM

Scott McDaniel

Show quote Hide quote

On Sun, 23 Jul 2006 06:38:15 GMT, "Aki" <aki_m***@hotmail.com> wrote:

>Hi
>We have a Access database for logging all the activities we do everyday. It
>was oreginally created and designed by one of my co-workers. Just about few
>days ago, he tried to add a person onto the user list for giving permission
>to edit some of the tables. However, somehow the whole system was screwed
>and now it won't let us in and shows message says that we don't have the
>administrative right. It now doesn't shows up any login window. We have
>done anything we can do tried to fix the problem, even replace the .mdw
>file, but still no luck.
>
>Is there anyone can tell me what we can do to make the database to bypass or
>remove the security setting? We've lost 19 days worth of log. It will be
>appreciated if any one of you can help us with this trouble. Thanks.

If your db is properly secured Access must use the exact mdw file which was used when creating it, and if it can't find
that file it won't open. Did you make a copy of the file before you replaced it? If so, try moving the original back
into place.

How do you open the database? Do you use a shortcut, or doubleclick the file directly?

If you use a shortcut, right-click the shortcut and examine the Target property; it'll probably look something like
this:

"Full path to MSACCESS.EXE" "Full path to your db" /wrkgrp "Full path to your .mdw file"

Make sure the .mdw file is in the path specified.

If you don't use a shortcut to open your db, then the machine was probably "joined" to a workgroup. Open Access, then
click Tools - Security - Workgroup Administrator to see what workgroup you're currently joined to. Is that the correct
workgroup? If not, try re-joinnig the original workgroup.

>

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

25 Jul 2006 4:44 AM

Aki

First, thank you for you response, Scott.

Unfortunately that my co-worker didnot keep a copy of the security.mdw or
system.mdw file after he implemented the security on the database. There is
a text file generated by Access after the implementation of security;
however, we tried to create a new mdw file by using those info in the text
file, but still no luck.

He told me that everything happened after he tried to add a new person and
password in the workgroup. After he clicked OK to accept the new setting
and restart the database, he can no longer open the file. It sounds to me
that he might have accidentally changed something about the administator
account, but only god knows what'd happened.

We have created a new copy of the database for current use. We run the
database on a monthly basis, which means we have lost "only" less than a
month of log, 19 days for exact. It may not sound a big deal. But, we are
a security department, and we are running the database as our daily activity
log, which logs almost everything. As I remember, until the time we lost
it, we already have about1400 records. It is actually a disaster for us.

If anyone can help me to at least get a copy of the main table out of the
database, it will be so appreciated.

Aki

Show quoteHide quote

"Scott McDaniel" <scott@NoSpam_Infotrakker.com> wrote in message
news:gro6c296ucfksrjftegtr3mlmdqvjlbb2o@4ax.com...
> On Sun, 23 Jul 2006 06:38:15 GMT, "Aki" <aki_m***@hotmail.com> wrote:
>
>>Hi
>>We have a Access database for logging all the activities we do everyday.
>>It
>>was oreginally created and designed by one of my co-workers. Just about
>>few
>>days ago, he tried to add a person onto the user list for giving
>>permission
>>to edit some of the tables. However, somehow the whole system was screwed
>>and now it won't let us in and shows message says that we don't have the
>>administrative right. It now doesn't shows up any login window. We have
>>done anything we can do tried to fix the problem, even replace the .mdw
>>file, but still no luck.
>>
>>Is there anyone can tell me what we can do to make the database to bypass
>>or
>>remove the security setting? We've lost 19 days worth of log. It will be
>>appreciated if any one of you can help us with this trouble. Thanks.
>
> If your db is properly secured Access must use the exact mdw file which
> was used when creating it, and if it can't find
> that file it won't open. Did you make a copy of the file before you
> replaced it? If so, try moving the original back
> into place.
>
> How do you open the database? Do you use a shortcut, or doubleclick the
> file directly?
>
> If you use a shortcut, right-click the shortcut and examine the Target
> property; it'll probably look something like
> this:
>
> "Full path to MSACCESS.EXE" "Full path to your db" /wrkgrp "Full path to
> your .mdw file"
>
> Make sure the .mdw file is in the path specified.
>
> If you don't use a shortcut to open your db, then the machine was probably
> "joined" to a workgroup. Open Access, then
> click Tools - Security - Workgroup Administrator to see what workgroup
> you're currently joined to. Is that the correct
> workgroup? If not, try re-joinnig the original workgroup.
>
>>
>
> Scott McDaniel
> scott@takemeout_infotrakker.com
> www.infotrakker.com