User Log-in problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

user451@anon.com - 18 Mar 2004 00:42 GMT

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.

Reply to this Message

Larry Linson - 18 Mar 2004 02:44 GMT

First, you should have split the database into front-end (queries, forms,
reports, macros, modules, and any local lookup tables) and back-end (tables,
relationships, and data). Each user should have a copy of the front-end on
his/her own machine, linked to the shared tables in the backend stored in a
folder to which all have full access. That's a start.

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

> 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,
[quoted text clipped - 8 lines]
> still doesn't work. Anyone have an answer ? Thank you in advance for
> any help.

Reply to this Message

Roger Carlson - 18 Mar 2004 21:38 GMT

Another resource is the Microsoft Security FAQ. It tells how to avoid some
common pitfalls when implementing security, such as naming your security
file SYSTEM.MDW, which is probably your problem.
You can find it from Microsoft, but I also have a copy on my website on the
Knowledge page:
http://www.rogersaccesslibrary.com/knowledge.html

Signature

--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Reply to this Message