How to set up database logon in a shared folder

[newbie]

Hi there
I use Access2002. I have designed a database in a router connected
workgroup envirament. I put it into my shared doc folder so everybody
in the workgroup have access to it. I want to have user level and
object level of security control. I have setup a workgroup and added
users to it. However, it only ask logon info when open it from my
computer, anyone from other computer seems to have access only as a
regular user by default without being asked for logon. How do I
activate a logon window for them so they can see different forms? Or
Is it possible to manage like this in a work group env? Also, one user
use the same version as me and she seems to have equal permission as
me as a Admin which is not desirable of course. Other users using 2000
version seem can only access as regular user.
Any tips or idea will be highly appreciated.

Regards

Donna

[Larry Linson]

"newbie" wrote

I use Access2002. I have designed a
database in a router connected
workgroup envirament. I put it into
my shared doc folder so everybody
in the workgroup have access to it.

It's not clear from your post... but if you have multiple users logged in to
the same front-end or monolithic database, you significantly increase the
probability that database will become corrupted.

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP