how to handle locked objects?

[Abby Lee]

Hi everyone,

I just inherited a Financial Access Database. As I understand it they
started with paradox and exported it into Access 2000 which is what it
is now.

Some things I try to open gives me the message: "You don't have
permission to run "Subaccount numbers." To run this object, you must
have Open/Run permission for it. For more information on permissions
and who can set them, click help.

I asked the person I inherited this from about this...she told me she
hasn't been able to use this and other db objects for some time. She
also told me everyone in the business office has full access to this
server object...there are no permissions set.

When I go to Tools --> Security --> User and Group Permissions
I see that the current owner is "<unknown>" and I can't seem to change
that.
I also see that everyone is using the "Admin" account. The previous
owner told me it had to be that way otherwise we would have it lock up
all the time...like in the past (what ever that means).

How do I clean out the old files?

[Tom van Stiphout]

Re: how to handle locked objects?

On 4 Aug 2004 13:05:10 -0700, abbylee26@hotma il.com (Abby Lee) wrote:

She is probably using a different workgroup file than you are.
The messages you are seeing are related to Access security, which is
an advanced topic. Download, study, and fully understand the Access
Security FAQ from microsoft.com before trying to tinker with it.

-Tom.

[color=blue]
>Hi everyone,
>
>I just inherited a Financial Access Database. As I understand it they
>started with paradox and exported it into Access 2000 which is what it
>is now.
>
>Some things I try to open gives me the message: "You don't have
>permission to run "Subaccount numbers." To run this object, you must
>have Open/Run permission for it. For more information on permissions
>and who can set them, click help.
>
>I asked the person I inherited this from about this...she told me she
>hasn't been able to use this and other db objects for some time. She
>also told me everyone in the business office has full access to this
>server object...there are no permissions set.
>
>When I go to Tools --> Security --> User and Group Permissions
>I see that the current owner is "<unknown>" and I can't seem to change
>that.
>I also see that everyone is using the "Admin" account. The previous
>owner told me it had to be that way otherwise we would have it lock up
>all the time...like in the past (what ever that means).
>
>How do I clean out the old files?[/color]

[Max]

Re: how to handle locked objects?

Hi,

If you are the only one who is going to use it in future and don't
want anything to do with security you can try to export the objects to
a new database that has no security file attached(in simple words
create a new database). Ask anyone who doesn't get the permission
denied message to export all the objects for old database to the new
database. It will give you a database without any security features.

Max