"na9999 via AccessMonster.com" <u43152@uwe> wrote in message news:83bf05bd37f98@uwe...
: Hi,
: I am setting up a shared workgroup file which is located on the server. The
: individual workstations are set to use this file in Workgroup Admin.
That really isn't a good idea, as you have now set the default mdw to your secure one; every session of Access will now require a login. A better method is to leave the computer joined to the system.mdw that ships with Access. Give the user a desktop shortcut to open the secured mdb. The target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
: But when
: around half of the users try and use Access thy get an error saying The
: 'Admin' file is in use. This is over Access 2002 and 2003. At the moment
: about half of users are having now problems, but the other half are not.
This could be a Windows permission problem. Double-check that all users have read/write/create/delete permission on the folder where the mdw is located. Also you haven't named the mdw the same as the mdb have you? They each need to create an associated ldb file, and can't if they have the same name.
Also you should split the mdb - give each user a copy of the frontend on their computer and leave the backend on the server. More information at
http://www.members.shaw.ca/AlbertKal...plit/index.htm
http://granite.ab.ca/access/splitapp/index.htm
--
Joan Wild
Microsoft Access MVP
Similar Threads
