Log-in / app problem

  • Thread starter Thread starter user451
  • Start date Start date
U

user451

I am trying to set-up a multi-user app, and I can't figure something
out. I have placed the app in a folder on a server on a W2K network,
and created a shortcut on each user's desktop. I set up the security
by opening the app on the share drive, logging in as admin, and then
creating user accounts. I can log in as admin or any user when I am at
the workstation I used to set-up the security. But when I try to
access the app from any other workstation, there is no prompt for
login and password. The app just starts. The same thing happens when
any other user logs in from anywhere on the network. What am I missing
? I have copied the system.mdw to the same drive as the app, but it
still doesn't work. Anyone have an answer ? Thank you in advance for
any help.
 
You are missing some very basic things about Access security. For example,
how Access chooses which workgroup information file to use when you open the
database. (It is nothing to do with that file being in the same folder as
the database.) Also, I suspect you have not created a new workgroup file
with a unique WID. This is one of the first steps in securing a database
properly.

Access security is very capable, but also quite complicated. I suggest you
get a recognized text, eg. the "Access Security FAQ" then:
- read it about 50 times;
- spend *at least a week* experimenting on throw-away databases, then
- start again, following the instructions *exactly*, to secure your
database.

HTH,
TC
 
Hi,

you will need to set command line parameters when opening
the database to ensure it looks at the correct system.mdw
on the server. In the properties of a shortcut put:

"path to MSACCESS.exe (local)" "path to front end
database" /wrkgrp "path to system.mdw on server"

HTH

Brian
 
I am trying to set-up a multi-user app, and I can't figure something
out. I have placed the app in a folder on a server on a W2K network,
and created a shortcut on each user's desktop. I set up the security
by opening the app on the share drive, logging in as admin, and then
creating user accounts.
Click to expand...

There is much more than that to setting up security. Download the security
FAQ and follow *every* step, in order.
I can log in as admin or any user when I am at
the workstation I used to set-up the security. But when I try to
access the app from any other workstation, there is no prompt for
login and password. The app just starts.
Click to expand...

That's because they are using their default system.mdw workgroup. If you
secured your mdb properly, they wouldn't be able to even open the mdb.
 
Back
Top