using access workgroups

[Guest]

i have been using the command line switch to specify a MDW file for my projects but feel that this should be able to be performed in code. up until now all i can change is the default workgroup. Any ideas?

 

[Joan Wild]

The mdw is used before your mdb even opens. So you wouldn't be able to run
code that is in that mdb to do this.


--
Joan Wild
Microsoft Access MVP

i have been using the command line switch to specify a MDW file for my

projects but feel that this should be able to be performed in code. up
until now all i can change is the default workgroup. Any ideas?

 

[Guest]

thanks Joa
however if i use the folling proceedur

Public Sub Setworkgroup(
Dim WGPath As Strin
WGPath = DbPath & "SSS2002.mdw

Application.SetDefaultWorkgroupFile Path:=WGPat

End Su

and check the workgroup administrator the workgroup for the open database has change
how come

 

[Joan Wild]

That will change the default, but won't change the mdw that is currently in
use. i.e. next time you open Access the default will be SSS2002.mdw and it
will use it, but that doesn't change it for the current session.