login screen missing

Z

zenonk

I have a 3 year old split Access database two clients and a server.
Yesterday, I attempted to add a third client. All went well except for
the fact that the login security screen does not come up on the new
one. How do I enable the same security as there is on the other two?
I just moved a copy of the client to the new machine. Do I need to do
something more?

thanks in advance,

Zenon
 
D

Douglas J. Steele

Am I correct in assuming that they can simply use the application without
logging in? If that's the case, security wasn't applied correctly in the
first place.

You'd be well advised to take a close look at the Access Security FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp

Read it thoroughly several times, and try applying security again on a copy
of the database, ensuring you don't leave out any steps.
 
Z

zenonk

I'm sorry, I didn't explain it properly. The initial two clients have
security applied (per the instructions in this FAQ) and work famously.
The new copy does not however and I thought it would since I just
copied and pasted an existing client. Did I miss something?
 
D

Douglas J. Steele

Please define what the problem is. What happens when the user tries to use
the copy?
 
Z

zenonk

When the user opens the copy, it launches directly into the client gui,
bypassing the login screen. The login determines the level of
permission for the user, meaning the admin has a login name and
password, the standard user has a different one. This will insure that
standard users muck up the data in no time...
 
D

Douglas J. Steele

In that case, security definitely was NOT applied correctly in the first
place.

One of the critical steps of applying security is to remove the Admin user
from the Admins group. The Admin id is the default one that users get logged
in with if they don't go through the login process. Since your user is able
to get into the database without provide an id, that means that step was not
carried out.
 
Z

zenonk

It's possible, but I followed the steps very closely when I applied
permissions, I deleted the admin after creating another full permission
user as I was supposed to. Also, it worked the first time I copied it
a few years ago. I was just thinking, the new machine has a newer
version of Access on it... could that be the reason?
 
J

Joan Wild

You are kidding yourself. You cannot delete the admin user.

It is clear that your mdb is *not* secured. The fact that someone can open
it using their default system.mdw confirms that.

Go to some workstation where you think it's secured. Use the workgroup
administrator to join the standard system.mdw workgroup file. Then
double-click your 'secure' mdb. If they are even able to open it, then you
have not secured it properly. It has nothing to do with this 'one' machine.
 
Z

zenonk

I am certainly no Access pro, please don't beat me up too much. Can
you tell me how to connect to the existing .mdw from the new client...
 
T

TC

If your database has not been properly secured, you should really go
back & start again (to do that properly), before you worry about how to
connect to the securing workgroup file from the new client.

HTH,
TC
 
Top