using access workgroups

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Asbur said:
i have been using the command line switch to specify a MDW file for my
Click to expand...
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?
 
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
 
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.
 
Back
Top