Home All Groups Group Topic Archive Search About

It won't let me in.

Author
29 Aug 2006 1:49 PM
Lori
Okay, I've got my database ready to go company wide. I run the security
wizard and set everyone up. Giving myself and two others full access to
everything and the remainder of the users access to enter and update data and
run reports only.  I click finish and the system gives me the snapshot of the
setup. Then it tells me I have to close and reopen the database.

When I reopen the database it tells me that I don't have the proper
permissions to access this database and won't let me in.  I've restored it
back to orignial and try again and get the same answer. HELP!
--
Lori A. Pong

Author
29 Aug 2006 2:20 PM
Lynn Trapp
Lori,
Were you prompted for a user name and password when you tried to open it?
Did you leave the password blank?

Show quoteHide quote
"Lori" <L***@discussions.microsoft.com> wrote in message
news:0C97C5C7-4863-444B-856B-0C8C904BBF69@microsoft.com...
> Okay, I've got my database ready to go company wide. I run the security
> wizard and set everyone up. Giving myself and two others full access to
> everything and the remainder of the users access to enter and update data
> and
> run reports only.  I click finish and the system gives me the snapshot of
> the
> setup. Then it tells me I have to close and reopen the database.
>
> When I reopen the database it tells me that I don't have the proper
> permissions to access this database and won't let me in.  I've restored it
> back to orignial and try again and get the same answer. HELP!
> --
> Lori A. Pong
Author
29 Aug 2006 3:05 PM
Lori
I entered in a password for myself and no I wasn't prompted for username or
password, it just automatically said I didn't have permission.
--
Lori A. Pong


Show quoteHide quote
"Lynn Trapp" wrote:

> Lori,
> Were you prompted for a user name and password when you tried to open it?
> Did you leave the password blank?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>
>
>
> "Lori" <L***@discussions.microsoft.com> wrote in message
> news:0C97C5C7-4863-444B-856B-0C8C904BBF69@microsoft.com...
> > Okay, I've got my database ready to go company wide. I run the security
> > wizard and set everyone up. Giving myself and two others full access to
> > everything and the remainder of the users access to enter and update data
> > and
> > run reports only.  I click finish and the system gives me the snapshot of
> > the
> > setup. Then it tells me I have to close and reopen the database.
> >
> > When I reopen the database it tells me that I don't have the proper
> > permissions to access this database and won't let me in.  I've restored it
> > back to orignial and try again and get the same answer. HELP!
> > --
> > Lori A. Pong
>
>
>
Author
29 Aug 2006 8:05 PM
Joan Wild
The wizard created a desktop shortcut for you to open the secure mdb - use
that.

You are trying to open it via a double-click in Windows Explorer, and you
aren't using the correct workgroup file.  The shortcut points to the secure
mdw.


--
Joan Wild
Microsoft Access MVP

Lori wrote:
Show quoteHide quote
> I entered in a password for myself and no I wasn't prompted for
> username or password, it just automatically said I didn't have
> permission. --
> Lori A. Pong
>
>
> "Lynn Trapp" wrote:
>
>> Lori,
>> Were you prompted for a user name and password when you tried to
>> open it? Did you leave the password blank?
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>> Jeff Conrad's Access Junkie List:
>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>
>>
>>
>> "Lori" <L***@discussions.microsoft.com> wrote in message
>> news:0C97C5C7-4863-444B-856B-0C8C904BBF69@microsoft.com...
>>> Okay, I've got my database ready to go company wide. I run the
>>> security wizard and set everyone up. Giving myself and two others
>>> full access to everything and the remainder of the users access to
>>> enter and update data and
>>> run reports only.  I click finish and the system gives me the
>>> snapshot of the
>>> setup. Then it tells me I have to close and reopen the database.
>>>
>>> When I reopen the database it tells me that I don't have the proper
>>> permissions to access this database and won't let me in.  I've
>>> restored it back to orignial and try again and get the same answer.
>>> HELP! --
>>> Lori A. Pong