No logon at other workstations

J

JennKriv

I have set up my security as layed out in "Running Access 2000", I can get
the logon prompt on my computer but it will not come up on any of the other
workstations, and so they are not able to access any info at all.
I went onto one of the workstations and it shows no user names or groups
under the security. What do I do? What would have caused this.
I had created a secured database before and it worked but I can't figure out
what happened with this one.
 
J

Joan Wild

On the other workstation, you are opening the database using the standard system.mdw that ships with Access. Given that you can even do this, tells you that it isn't secured properly. I don't know what your book tells you, but if it calls for running the security wizard in 2000, then it's wrong.

It's actually a good test to see if you've implemented security properly - try to open the secured mdb using system.mdw.

You need to start over. Here are a few other resources:
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

--
Joan Wild
Microsoft Access MVP
:I have set up my security as layed out in "Running Access 2000", I can get
: the logon prompt on my computer but it will not come up on any of the other
: workstations, and so they are not able to access any info at all.
: I went onto one of the workstations and it shows no user names or groups
: under the security. What do I do? What would have caused this.
: I had created a secured database before and it worked but I can't figure out
: what happened with this one.
 
J

Joan Wild

All I can say is that you missed a step. It's important that you follow every step (every phrase), in order. You only have to miss one small seemingly unimportant thing, and it won't work.

--
Joan Wild
Microsoft Access MVP
:I did the same as your site www.jmwild.com/AccessSecurity.htm says. So I
: don't knwo what to do.
:
: "Joan Wild" wrote:
:
: > On the other workstation, you are opening the database using the standard system.mdw that ships with Access. Given that you can even do this, tells you that it isn't secured properly. I don't know what your book tells you, but if it calls for running the security wizard in 2000, then it's wrong.
: >
: > It's actually a good test to see if you've implemented security properly - try to open the secured mdb using system.mdw.
: >
: > You need to start over. Here are a few other resources:
: > Security FAQ
: > http://support.microsoft.com/?id=207793
: >
: > Security Whitepaper
: > http://support.microsoft.com/?id=148555
: >
: > Although the whitepaper is old, it contains information to help you understand security.
: >
: > I've also outlined the detailed steps at
: > www.jmwild.com/AccessSecurity.htm
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > :I have set up my security as layed out in "Running Access 2000", I can get
: > : the logon prompt on my computer but it will not come up on any of the other
: > : workstations, and so they are not able to access any info at all.
: > : I went onto one of the workstations and it shows no user names or groups
: > : under the security. What do I do? What would have caused this.
: > : I had created a secured database before and it worked but I can't figure out
: > : what happened with this one.
: >
 
J

JennKriv

So this is what I have for my target
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE""L:\Basic Data\Access
Databases\ApolloDatabase.mdb""L:\Basic data\Access Databases\system.mdw"

And I get an error that the target cannot be found. I am not sure what I am
missing.
 
D

Douglas J. Steele

There needs to be spaces between the double quotes. As well, you're missing
the /wrkgrp flag to indicate the workgroup file:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "L:\Basic
Data\Access Databases\ApolloDatabase.mdb" /wrkgrp"L:\Basic data\Access
Databases\system.mdw"
 
J

Joan Wild

Also there is a space between /wrkgrp and "L:\Basic.....

--
Joan Wild
Microsoft Access MVP
: There needs to be spaces between the double quotes. As well, you're missing
: the /wrkgrp flag to indicate the workgroup file:
:
: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "L:\Basic
: Data\Access Databases\ApolloDatabase.mdb" /wrkgrp"L:\Basic data\Access
: Databases\system.mdw"
:
: --
: Doug Steele, Microsoft Access MVP
:
: (no private e-mails, please)
:
:
: : > So this is what I have for my target
: > "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE""L:\Basic
: > Data\Access
: > Databases\ApolloDatabase.mdb""L:\Basic data\Access Databases\system.mdw"
: >
: > And I get an error that the target cannot be found. I am not sure what I
: > am
: > missing.
: >
: >
: > "Joan Wild" wrote:
: >
: >> All I can say is that you missed a step. It's important that you follow
: >> every step (every phrase), in order. You only have to miss one small
: >> seemingly unimportant thing, and it won't work.
: >>
: >> --
: >> Joan Wild
: >> Microsoft Access MVP
: >> : >> :I did the same as your site www.jmwild.com/AccessSecurity.htm says. So I
: >> : don't knwo what to do.
: >> :
: >> : "Joan Wild" wrote:
: >> :
: >> : > On the other workstation, you are opening the database using the
: >> standard system.mdw that ships with Access. Given that you can even do
: >> this, tells you that it isn't secured properly. I don't know what your
: >> book tells you, but if it calls for running the security wizard in 2000,
: >> then it's wrong.
: >> : >
: >> : > It's actually a good test to see if you've implemented security
: >> properly - try to open the secured mdb using system.mdw.
: >> : >
: >> : > You need to start over. Here are a few other resources:
: >> : > Security FAQ
: >> : > http://support.microsoft.com/?id=207793
: >> : >
: >> : > Security Whitepaper
: >> : > http://support.microsoft.com/?id=148555
: >> : >
: >> : > Although the whitepaper is old, it contains information to help you
: >> understand security.
: >> : >
: >> : > I've also outlined the detailed steps at
: >> : > www.jmwild.com/AccessSecurity.htm
: >> : >
: >> : > --
: >> : > Joan Wild
: >> : > Microsoft Access MVP
: >> : >> : > :I have set up my security as layed out in "Running Access 2000", I
: >> can get
: >> : > : the logon prompt on my computer but it will not come up on any of
: >> the other
: >> : > : workstations, and so they are not able to access any info at all.
: >> : > : I went onto one of the workstations and it shows no user names or
: >> groups
: >> : > : under the security. What do I do? What would have caused this.
: >> : > : I had created a secured database before and it worked but I can't
: >> figure out
: >> : > : what happened with this one.
: >> : >
: >>
:
:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top