Using Access 2000 on Windows 2000 SP4 I put user-level
security on ONE of my shared database files but now ALL of
my database files ask for the same ID and password - even
ones I try to create fresh from a blank database. If I
open one of the previously unsecured files at another
workststion the files open normally. I assume this is
caused by some configuration option at the original
workstation. Is there a way to remove security from the
other files but leave the one with it's security intact?

Thanx - Rick

You need to re-join the original workgroup security file so that
Access opens by default without any security. Then you need to
construct a special shortcut for the "secure" database so that its
session of Access opens using the secure workgroup file.

See the Microsoft security FAQ or my own document for additional
information. Links in the website in my signature.


On Mon, 25 Aug 2003 08:12:59 -0700, "Rick Cochran"
<(E-Mail Removed)> wrote:

>Using Access 2000 on Windows 2000 SP4 I put user-level
>security on ONE of my shared database files but now ALL of
>my database files ask for the same ID and password - even
>ones I try to create fresh from a blank database. If I
>open one of the previously unsecured files at another
>workststion the files open normally. I assume this is
>caused by some configuration option at the original
>workstation. Is there a way to remove security from the
>other files but leave the one with it's security intact?
>
>Thanx - Rick
>
>
>


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd

Along the same lines as Jack was on, how are you starting Access? Are
you using a shortcut? If so it is likely that shortcut is setup to ask for
the password. That should not be a problem since it will still open
un-protected and protected files.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


"Rick Cochran" <(E-Mail Removed)> wrote in message
news:0b3b01c36b1b$5ed59310$(E-Mail Removed)...
> Using Access 2000 on Windows 2000 SP4 I put user-level
> security on ONE of my shared database files but now ALL of
> my database files ask for the same ID and password - even
> ones I try to create fresh from a blank database. If I
> open one of the previously unsecured files at another
> workststion the files open normally. I assume this is
> caused by some configuration option at the original
> workstation. Is there a way to remove security from the
> other files but leave the one with it's security intact?
>
> Thanx - Rick
>
>
>
>

Thanx for the help guys, your suggestions did the trick.

Rick

>-----Original Message-----
> Along the same lines as Jack was on, how are you
starting Access? Are
>you using a shortcut? If so it is likely that shortcut
is setup to ask for
>the password. That should not be a problem since it will
still open
>un-protected and protected files.
>
>--
>Joseph E. Meehan
>
>26 + 6 = 1 It's Irish Math
>
>
>"Rick Cochran" <(E-Mail Removed)> wrote in
message
>news:0b3b01c36b1b$5ed59310$(E-Mail Removed)...
>> Using Access 2000 on Windows 2000 SP4 I put user-level
>> security on ONE of my shared database files but now ALL
of
>> my database files ask for the same ID and password -
even
>> ones I try to create fresh from a blank database. If I
>> open one of the previously unsecured files at another
>> workststion the files open normally. I assume this is
>> caused by some configuration option at the original
>> workstation. Is there a way to remove security from the
>> other files but leave the one with it's security intact?
>>
>> Thanx - Rick
>>
>>
>>
>>
>
>
>.
>