Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Columbus, OH
    Posts
    36

    Question Unanswered: How do I revert to default System.mdw after doing a SetDefaultWorkgroupFile?

    I am doing the following in code to set the default workgroup file:

    Application.SetDefaultWorkgroupFile "c:\myworkgroup.mdw"

    How do I find out what the current workgroup is before I do this so I can revert? Is there something built into Access?

    Thanks,
    Greg
    Greg Finzer
    http://www.kellermansoftware.com
    .NET Components

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you can either do that by specifying a workgroup on start up.. do a google on the command line switches of Access

    offhand its somethign like
    path/to/access.exe /w<path/to/workgroup.mdw>

    you should also be able to set a workgroup through the tools | security settigns
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2004
    Location
    Columbus, OH
    Posts
    36

    GetObject

    Heal,

    The problem with the command line approach is that I can't figure out how to get a specific Access instance with GetObject. The end goal is to be able to get to the Access Objects; forms, reports etc. I have three instances running; one database with the VBA code and two databases that I am comparing the Access objects.
    Greg Finzer
    http://www.kellermansoftware.com
    .NET Components

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •