Results 1 to 7 of 7
  1. #1
    metsmaniac is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    10

    Change Access 2003 mdb workgroup using Access 2010

    I just upgraded to Access 2010 from 2003. With 2003, I was able to open protected mdb files using Workgroup Administrator and joining (changing) the workgroup. This was done BEFORE opening the mdb file.



    I can't do this with Access 2010 - there's no option to change a workgroup.

    I scoured the internet for an answer. The closest one suggested creating a shortcut and having the target point to the Access application, then the mdb file, then use a "wrkgrp" command to point to the workgroup file (all this in one space-divided string). The answer related to Access 2007, and it doesn't work in 2010 (unless I'm doing something wrong).

    Anyone have another suggestion?
    Thanks.

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    I have always used a shortcut to select the correct work group file.

    In Access 2010 try:

    docmd.RunCommand acCmdWorkgroupAdministrator

  3. #3
    metsmaniac is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    10
    Can you please clarify how & where this shortcut is created? Thanks.

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    You create a standard windows shortcut with the target of:

    “full path to msaccess.exe” “full path to mdb” /wrkgrp “full path to secure mdw”


    For additional information see: Access User-Level Security

  5. #5
    metsmaniac is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    10
    I guess the 25th time is the charm. I tried that solution about 2 dozen times last week without success. Today it worked. Probably some keystroke error on my part before.

    Thank you very much for your help.

  6. #6
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    You're welcome.

    Glad to hear it is working for you now.

  7. #7
    SynerSoft is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    1

    Cool Thanks!

    This was the perfect solution! I created a new db, created a new module, then pasted "docmd.RunCommand acCmdWorkgroupAdministrator" into the immediate window. Success! Now I can address those nasty 64-bit PtrSafe Declare messages!

    Thanks again!

    -Jay


    Quote Originally Posted by HiTechCoach View Post
    I have always used a shortcut to select the correct work group file.

    In Access 2010 try:

    docmd.RunCommand acCmdWorkgroupAdministrator

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Opening Access 2000 file in Access 2010
    By Jacob in forum Access
    Replies: 10
    Last Post: 02-12-2011, 06:56 AM
  2. Replies: 1
    Last Post: 01-11-2011, 12:31 PM
  3. workgroup administrator in 2010
    By cpcp in forum Access
    Replies: 0
    Last Post: 10-26-2010, 04:31 AM
  4. Convert access 2003 to access 2010
    By Vera in forum Access
    Replies: 3
    Last Post: 07-16-2010, 11:01 AM
  5. Replies: 1
    Last Post: 09-06-2006, 11:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums