By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,176 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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?

Nov 12 '05 #2

P: n/a
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?


Nov 12 '05 #3

P: n/a
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?

Nov 12 '05 #4

P: n/a
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.


Nov 12 '05 #5

P: n/a
"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
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.