Re: Only one user can log in at a time problem.
From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 03/24/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: Access Security not secure"
- Previous message: Hattie: "setting security back to default settings"
- In reply to: Cam: "Re: Only one user can log in at a time problem."
- Next in thread: Joan Wild: "Re: Only one user can log in at a time problem."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Mar 2004 10:56:52 -0500
They don't need to be in separate folders, but I would double-check by
testing that users can create and delete a text file in all the folders
involved. See my other post from yesterday.
-- Joan Wild Microsoft Access MVP "Cam" <anonymous@discussions.microsoft.com> wrote in message news:1235b01c4113d$288ea210$a501280a@phx.gbl... > Hi Joan, > > The be mdb is located in the MQA Database folder, where > the mdw is in the Workgroup folder, which is inside the > MQA Database folder. > The name of the be is MfgLog02_be. > > > >-----Original Message----- > >Is the backend mdb also located in the same folder as the > mdw? What is the > >name of the backend? > > > > > >-- > >Joan Wild > >Microsoft Access MVP > > > >"Cam" <anonymous@discussions.microsoft.com> wrote in > message > >news:f3d801c4110a$a34ffd10$a601280a@phx.gbl... > >> Hi Joan, It's me again. > >> > >> I noticed one thing that might help you understand the > >> issue I am having. > >> 1) When I check on the "Ownership" in the Properties > under > >> the Security tab (right click on the database file), I > >> noticed the owner is "LOU001\Adminstrators", LOU001 is > my > >> computer name. But when I did the same check for the MDW > >> and BE file in the network, it said the owner is "loulc > >> (Full name)", which is my Windows NT log in name. > >> 2) The shortcut I created for users is: "C:\Program > >> Files\Microsoft Office\Office\msaccess.exe" "C:\MQA > >> > Database\MfgLog02.mdb" /wrkgrp "\\Tual\Shared\Quality\MQA > >> Database\Workgroup\MQA.mdw" > >> 3) We are using Windows NT for the network and MS Access > >> 97. > >> > >> I hope this will explain a little more. Thanks again. > >> > >> >-----Original Message----- > >> >Hi Joan, > >> > > >> >I checked with the System Admins and all users do have > >> >read, write, modify permissions to the folders. But I > am > >> >still having the same problem. > >> > > >> >Once I log into the database from one computer as users > >> >account, it display the message: "Couldn't use (the > >> >path to the workgroup MDW file); file already in use." > >> >when another users try to log into the database from > >> >another computer. > >> > > >> >Thanks for any other sugguestion. > >> > > >> >>-----Original Message----- > >> >>Hi Cam, > >> >> > >> >>"Cam" <anonymous@discussions.microsoft.com> wrote in > >> >message > >> >>news:e8ce01c4102f$daec8ee0$a601280a@phx.gbl... > >> >>> Hello Joan, > >> >>> > >> >>> Thanks for your sugguestion. > >> >>> 1) Only System Admin can change permissions on the > >> >folder > >> >>> in the network drive. > >> >> > >> >>Naturally, so tell them to give the users modify > >> >permissions. This is not > >> >>optional - all users need this access in order to > create > >> >the associated ldb > >> >>files. If they don't have it, the first person in > won't > >> >be able to create > >> >>the ldb and the mdb will be opened exclusively. > >> >> > >> >>> 2) So, your sugguestion is to create individual > users > >> >>> account and join them to the users (only) permission > >> >group. > >> >> > >> >>No I mean, in Access, create a single group. Grant > >> >whatever permissions you > >> >>like to this group. Then you can create users and > make > >> >them a member of > >> >>this group. You won't have to assign permissions to > the > >> >user at all - > >> >>they'll inherit the needed permissions from the group. > >> >That way, if you add > >> >>new objects, you only have to assign permissions to > the > >> >group (rather than > >> >>to each and every user). > >> >> > >> >>> Will this solve the problem that only one user can > log > >> & > >> >>> open the database at a time? > >> >> > >> >>No see above - they must have modify permission on the > >> >folder.-- > >> >> > >> >>Joan Wild > >> >>Microsoft Access MVP > >> >> > >> >> > >> >>. > >> >> > >> >. > >> > > > > > > >. > >
- Next message: anonymous_at_discussions.microsoft.com: "Re: Access Security not secure"
- Previous message: Hattie: "setting security back to default settings"
- In reply to: Cam: "Re: Only one user can log in at a time problem."
- Next in thread: Joan Wild: "Re: Only one user can log in at a time problem."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
