Define workgroup on activate event?

[Guest]

I would like to know if it is possible for an .mdb database to define
its workgroup when it opens. I'm currently using a windows shortcut with
the /wrkgrp flag pointing at my workgroup file, but I have many
databases, and it's a bit clunky to have a shortcut file for each
database I need to distribute and move (and may be near impossible to
tell my users to click on the shortcut, not the .mdb file!) Is there any
way I can set the workgroup file without using a shortcut, such as using
VBA on the activate() event?

Nathan

 

[Joan Wild]

NoSpamTakeSquareRootOfNumber" <"nlee144(NoSpamTakeSquareRootOfNumber)
wrote:

I would like to know if it is possible for an .mdb database to define
its workgroup when it opens. I'm currently using a windows shortcut
with the /wrkgrp flag pointing at my workgroup file, but I have many
databases, and it's a bit clunky to have a shortcut file for each
database I need to distribute and move (and may be near impossible to
tell my users to click on the shortcut, not the .mdb file!) Is there
any way I can set the workgroup file without using a shortcut, such
as using VBA on the activate() event?

Nathan

Short answer is no. You can't fire any events until after the mdb is open,
which is after the workgroup is opened.

Also if the users click on the mdb file directly, they shouldn't be able to
even open it unless they're joined to the correct workgroup file.

Reading between the lines here....you don't have to create a separate
workgroup file for every database. You could secure all of them using one,
and then join them to this workgroup file.

 

[Guest]

I didn't think there would be a way, but it was worth checking.
I don't need each database to have its own workgroup file, I just these
databases to use a workgroup file shared on a server. I can't change
everyone's computer configuration because then that would interfere with
the databases they already use on their computers.

Thanks for your response!