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

How to set up database logon in a shared folder

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


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

This discussion thread is closed

Replies have been disabled for this discussion.