Re: Workgroup MS Access 2003 Windows XP

"JaBo" <JaBo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A7960F90-F679-493F-911C-325955392281@xxxxxxxxxxxxxxxx
> Our company computers were recently upgraded to Windows XP with Microsoft
> Office 2003. We have 3 different Access Databases (in different
> directories
> on our network) which all require the user to be part of a "Workgroup". It
> appears that Access 2003 includes some added security features that
> prevent
> the user from accessing a database unless you join the workgroup
> corresponding to the database. This works fine, unless you need to join
> multiple workgroups. For example, to log into database "x" you must join
> the
> "x" workgroup, and then to log into database "y" you must join the "y"
> workgroup each time you attempt to open it. So far, we have figured out
> how
> to join one workgroup, but not many at the same time. We would greatly
> appreciate it if anybody had advice regarding this issue.


I am surprised you didn't have to do this before the upgrade. You need to
leave users joined to the standard system.mdw. Then create three desktop
shortcuts for the three secure mdbs. The target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

Perhaps the users had desktop shortcuts before the upgrade?

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • RE: From Workgroup to Domain...now can not access database
    ... effect those still in a workgroup? ... >Microsoft Security Bulletin MS03-026? ...
    (microsoft.public.access.security)
  • Re: Read only message
    ... same Workgroup file they were using before the upgrade. ... Workgroup Administrator had been used to join them to the workgroup as their ... > They are only able to open the database as read only and are not able to ...
    (microsoft.public.access.forms)
  • Re: Loading 2000 Standard DB into 2005 Workgroups?
    ... It generally works just fine but as with any upgrade, ... Now I assume I backup the database, ... install 2005 Workgroup and then import the backup. ...
    (microsoft.public.sqlserver.setup)
  • Re: WSUS 2 to WSUS 3 migration guide
    ... So basically after the upgrade is done we shouldn't have to reconfigure ... any of the settings on the wsus. ... I'm Sean Cai from Microsoft CIBS OS & APP team and I'll helping you on ... database corruption. ...
    (microsoft.public.windows.server.migration)
  • RE: Does Access 97 Qualify For the Upgrade to Access 2003
    ... Yes it does qualify for Access 2003 upgrade. ... previous versions nothing has changed (it's per database). ... Microsoft Access Support ... Microsoft Security Bulletin MS03-026? ...
    (microsoft.public.access.gettingstarted)