How do I get back into a database as the administrator once I hav.

13 Apr 2005 11:43 AM

JTS

How do I get back into a database as the administrator once I have given
another user permission? Right now I'm locked out and can't figure out a way
to get back in.

I would appreciate any help because as it looks right nowI'm going to have
to build the database all over.

13 Apr 2005 12:28 PM

Lynn Trapp

I'm not totally sure what your problem is. Are you getting an error message
when you attempt to open the database?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

Show quoteHide quote

"JTS" <J**@discussions.microsoft.com> wrote in message
news:6C334A97-CC5E-4ED7-BB9C-28E9ABA962A4@microsoft.com...
> How do I get back into a database as the administrator once I have given
> another user permission? Right now I'm locked out and can't figure out a
> way
> to get back in.
>
> I would appreciate any help because as it looks right nowI'm going to have
> to build the database all over.

13 Apr 2005 1:20 PM

Andrew Gallimore

I think I might be having the same problem. I get an error message when
trying to open one of my databases that says "You do not have the necessary
permissions... Have your system administrator or person who created this
object establish the appropriate permissions for you."

How do I get back in? I am the creator of the object.

Show quoteHide quote

"Lynn Trapp" wrote:

> I'm not totally sure what your problem is. Are you getting an error message
> when you attempt to open the database?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
>
>
> "JTS" <J**@discussions.microsoft.com> wrote in message
> news:6C334A97-CC5E-4ED7-BB9C-28E9ABA962A4@microsoft.com...
> > How do I get back into a database as the administrator once I have given
> > another user permission? Right now I'm locked out and can't figure out a
> > way
> > to get back in.
> >
> > I would appreciate any help because as it looks right nowI'm going to have
> > to build the database all over.
>
>
>

13 Apr 2005 1:27 PM

JTS

The problem is I am the creator of the database. I gave user permission to
someone else, which somehow got me locked out of the database. I am now
getting the message that "You don't have the necessary permissions..." Is
there anyway to regain access as a full administrator?

Show quoteHide quote

"Andrew Gallimore" wrote:

> I think I might be having the same problem. I get an error message when
> trying to open one of my databases that says "You do not have the necessary
> permissions... Have your system administrator or person who created this
> object establish the appropriate permissions for you."
>
> How do I get back in? I am the creator of the object.
>
> "Lynn Trapp" wrote:
>
> > I'm not totally sure what your problem is. Are you getting an error message
> > when you attempt to open the database?
> >
> > --
> > Lynn Trapp
> > MS Access MVP
> > www.ltcomputerdesigns.com
> > Access Security: www.ltcomputerdesigns.com/Security.htm
> > Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
> >
> >
> > "JTS" <J**@discussions.microsoft.com> wrote in message
> > news:6C334A97-CC5E-4ED7-BB9C-28E9ABA962A4@microsoft.com...
> > > How do I get back into a database as the administrator once I have given
> > > another user permission? Right now I'm locked out and can't figure out a
> > > way
> > > to get back in.
> > >
> > > I would appreciate any help because as it looks right nowI'm going to have
> > > to build the database all over.
> >
> >
> >

13 Apr 2005 2:04 PM

Keith

"JTS" <J**@discussions.microsoft.com> wrote in message
news:5354F247-983C-42FF-B3EC-F75C2A07263E@microsoft.com...
> The problem is I am the creator of the database. I gave user permission
> to
> someone else, which somehow got me locked out of the database. I am now
> getting the message that "You don't have the necessary permissions..." Is
> there anyway to regain access as a full administrator?
>

Can you change permissions whilst logged on as the other user? Does holding
the shift key down as you open it help? I fear you may have learned the
hard way that you should always work on copies of your files.

regards,
Keith.
www.keithwilby.com