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\system32\Wrkgadm.exe
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]

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

"C:\program files\microsoft office\office\msaccess.exe" /wrkgrp "C:\my
documents\YourMdwFile.mdw"

"MLH" <CR**@NorthState.net> wrote in message
news:cf********************************@4ax.com...

With Access 2.0, it was simple.
97 doesn't seem so obvious.
Where do I start. I launched
c:\windows\system32\Wrkgadm.exe
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?

[MLH]

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.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxx
On Mon, 13 Oct 2003 16:39:16 -0400, "Saintor"
<sa******@REMOVETHIShotmail.com> wrote:

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

"C:\program files\microsoft office\office\msaccess.exe" /wrkgrp "C:\my
documents\YourMdwFile.mdw"

"MLH" <CR**@NorthState.net> wrote in message
news:cf********************************@4ax.com.. .

With Access 2.0, it was simple.
97 doesn't seem so obvious.
Where do I start. I launched
c:\windows\system32\Wrkgadm.exe
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?

[Scott McDaniel]

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
www.thedatabaseplace.net

"MLH" <CR**@NorthState.net> wrote in message
news:j7********************************@4ax.com...

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.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxx
On Mon, 13 Oct 2003 16:39:16 -0400, "Saintor"
<sa******@REMOVETHIShotmail.com> wrote:

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

"C:\program files\microsoft office\office\msaccess.exe" /wrkgrp "C:\my
documents\YourMdwFile.mdw"

"MLH" <CR**@NorthState.net> wrote in message
news:cf********************************@4ax.com.. .

With Access 2.0, it was simple.
97 doesn't seem so obvious.
Where do I start. I launched
c:\windows\system32\Wrkgadm.exe
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?

[MLH]

Well deserved advice. No doubt about it. Thank-you much.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxx
On Mon, 13 Oct 2003 20:40:35 -0400, "Scott McDaniel"
<scott@NOSPAM__thedatabaseplace.net> wrote:

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.

[Keith Wilby]

"Scott McDaniel" <scott@NOSPAM__thedatabaseplace.net> wrote:

MS Access security is, by it's nature, very
complex ... you can lock yourself out of your database permanently if you
setup security wrong.

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

www.keithwilby.org.uk