Re: DB locked - what have I done?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 06:56:22 -0800

Hi, Kate.

> This
> one says I have to ask the administrator to change my permissions.

This sounds like a message that Access is giving you, not the operating
system. If so, the database has been secured and you, as the default Admin
user, no longer have "Open/Run Database" permission.

> How did I manage to lock myself out of an unsecured db and is there any
way
> I can fix it?

You may have had help. Have either you or your colleague been playing with
Access's built-in user-level security for any other Access databases?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Kate" <Kate@discussions.microsoft.com> wrote in message
news:405DA747-40EE-411B-87C5-0243D98619D5@microsoft.com...
> Thank you for your quick reply. I was the creator! I am also the admin.
> When I right-click on the file icon I have all except special permissions
and
> I have changed the macro security to low. All my other dbs are fine.
This
> one says I have to ask the administrator to change my permissions.
>
> How did I manage to lock myself out of an unsecured db and is there any
way
> I can fix it?
>
>
> "'69 Camaro" wrote:
>
> > Hi, Kate.
> >
> > > I don't know what I did last time but evidently I
> > > clicked the wrong button because now the database will not open at
all -
> > > tells us both that we do not have permission. I am owner and have
admin
> > > permission so what is going on? Have to say this is a really annoying
> > > "feature" of 2003, Microsoft....
> >
> > The database application you are attempting to open has not been
digitally
> > signed by the creator to guarantee that it is safe from viruses. You
can
> > ask the creator to digitally sign the application or you can set your
macro
> > security setting to low to avoid the warning messages altogether.
> >
> > To change the macro security setting to low (which is what most of us
are
> > doing for the time being until digital signatures become more
commonplace),
> > open Microsoft Access 2003, select the Tools menu -> Macro ->
Security... to
> > open the Security dialog window. Select the "Low" option and select the
> > "OK" button to save your change. The next time you open an Access
database,
> > this new setting will be used.
> >
> > HTH.
> >
> > Gunny
> >
> > See http://www.QBuilt.com for all your database needs.
> > See http://www.Access.QBuilt.com for Microsoft Access tips.
> >
> > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> > will be forwarded to me.)
> >
> >
> > "Kate" <Kate@discussions.microsoft.com> wrote in message
> > news:98C7A758-5941-47D0-97F2-DA45D415A042@microsoft.com...
> > > Have a db used by self and colleague on server. I have upgraded to
Access
> > > 2003 but colleague still on XP. I was getting these annoying security
> > > messages, did update and everything but still having to click no and
> > cancel
> > > 3x before file would open. I don't know what I did last time but
> > evidently I
> > > clicked the wrong button because now the database will not open at
all -
> > > tells us both that we do not have permission. I am owner and have
admin
> > > permission so what is going on? Have to say this is a really annoying
> > > "feature" of 2003, Microsoft....
> >
> >
> >

Quantcast