How do I set up Access 97 security to require a login ID & pass when launching Access 97?

[MLH]

With Access 2.0, it was simple.
97 doesn't seem so obvious.
Where do I start. I launched
c:\windows\syst em32\Wrkgadm.ex e
and joined system.mdw in that
same dir. Upon launching Access
97, I wasn't prompted for a name
'n pass. What should I do?

[Saintor]

Re: How do I set up Access 97 security to require a login ID & pass when launching Access 97?

The most reliable way is always to use the /wrkgrp switch command. See in
the online help.

"C:\program files\microsoft office\office\m saccess.exe" /wrkgrp "C:\my
documents\YourM dwFile.mdw"

"MLH" <CRCI@NorthStat e.net> wrote in message
news:cf1mov8cqj n3uc36cucoglm41 jajkl02g1@4ax.c om...[color=blue]
> With Access 2.0, it was simple.
> 97 doesn't seem so obvious.
> Where do I start. I launched
> c:\windows\syst em32\Wrkgadm.ex e
> and joined system.mdw in that
> same dir. Upon launching Access
> 97, I wasn't prompted for a name
> 'n pass. What should I do?[/color]

[MLH]

Re: How do I set up Access 97 security to require a login ID &amp; pass when launching Access 97?

Thx, Saintor. I was actually having a braindead moment.
I overlooked the fact that after joining the system.mdw
workgroup, I still had to assign user "Admin" a password
before I would get the logon name 'n pass prompt. Thank-
you.

xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx x


On Mon, 13 Oct 2003 16:39:16 -0400, "Saintor"
<saintor1@REMOV ETHIShotmail.co m> wrote:
[color=blue]
>The most reliable way is always to use the /wrkgrp switch command. See in
>the online help.
>
>"C:\program files\microsoft office\office\m saccess.exe" /wrkgrp "C:\my
>documents\Your MdwFile.mdw"
>
>"MLH" <CRCI@NorthStat e.net> wrote in message
>news:cf1mov8cq jn3uc36cucoglm4 1jajkl02g1@4ax. com...[color=green]
>> With Access 2.0, it was simple.
>> 97 doesn't seem so obvious.
>> Where do I start. I launched
>> c:\windows\syst em32\Wrkgadm.ex e
>> and joined system.mdw in that
>> same dir. Upon launching Access
>> 97, I wasn't prompted for a name
>> 'n pass. What should I do?[/color]
>[/color]

[Scott McDaniel]

Re: How do I set up Access 97 security to require a login ID &amp; pass when launching Access 97?

You should NOT assign permissions and such through the System.mdw ...
instead, create a new Workgroup and use that to secure your database. Before
you attempt this, however, download and read-read-read the MS Security FAQ
(available from the MS website). MS Access security is, by it's nature, very
complex ... you can lock yourself out of your database permanently if you
setup security wrong.
--
Scott McDaniel
CS Computer Software

https://www.thedatabaseplace.net

"MLH" <CRCI@NorthStat e.net> wrote in message
news:j74movg1b8 6itdsk4e4g3fik7 cbsh04d0a@4ax.c om...[color=blue]
> Thx, Saintor. I was actually having a braindead moment.
> I overlooked the fact that after joining the system.mdw
> workgroup, I still had to assign user "Admin" a password
> before I would get the logon name 'n pass prompt. Thank-
> you.
>
> xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx x
>
>
> On Mon, 13 Oct 2003 16:39:16 -0400, "Saintor"
> <saintor1@REMOV ETHIShotmail.co m> wrote:
>[color=green]
> >The most reliable way is always to use the /wrkgrp switch command. See[/color][/color]
in[color=blue][color=green]
> >the online help.
> >
> >"C:\program files\microsoft office\office\m saccess.exe" /wrkgrp "C:\my
> >documents\Your MdwFile.mdw"
> >
> >"MLH" <CRCI@NorthStat e.net> wrote in message
> >news:cf1mov8cq jn3uc36cucoglm4 1jajkl02g1@4ax. com...[color=darkred]
> >> With Access 2.0, it was simple.
> >> 97 doesn't seem so obvious.
> >> Where do I start. I launched
> >> c:\windows\syst em32\Wrkgadm.ex e
> >> and joined system.mdw in that
> >> same dir. Upon launching Access
> >> 97, I wasn't prompted for a name
> >> 'n pass. What should I do?[/color]
> >[/color]
>[/color]

[MLH]

Re: How do I set up Access 97 security to require a login ID &amp; pass when launching Access 97?

Well deserved advice. No doubt about it. Thank-you much.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx


On Mon, 13 Oct 2003 20:40:35 -0400, "Scott McDaniel"
<scott@NOSPAM__ thedatabaseplac e.net> wrote:
[color=blue]
>You should NOT assign permissions and such through the System.mdw ...
>instead, create a new Workgroup and use that to secure your database. Before
>you attempt this, however, download and read-read-read the MS Security FAQ
>(available from the MS website). MS Access security is, by it's nature, very
>complex ... you can lock yourself out of your database permanently if you
>setup security wrong.[/color]

[Keith Wilby]

Re: How do I set up Access 97 security to require a login ID &amp; pass when launching Access 97?

"Scott McDaniel" <scott@NOSPAM__ thedatabaseplac e.net> wrote:
[color=blue]
> MS Access security is, by it's nature, very
> complex ... you can lock yourself out of your database permanently if you
> setup security wrong.
>[/color]

In addition to the MS FAQ on the subject, there's a beginners' guide on my
web site that you might find useful.

https://www.keithwilby.org.uk