Problems with Workgroup file

[na9999 via AccessMonster.com]

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. 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.

Everyone receives the error at first, but after forcing access to make the
user login, half work?

Help!!

Thanks

 

[Joan Wild]

: 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/AlbertKallal/Articles/split/index.htm
http://granite.ab.ca/access/splitapp/index.htm

 

[david]

What kind of server? How many connections are licenced?
(david)