I have two large complex Access 2003 databases where one uses 'GetObject' to
open the second and then I run a macro within it. This works fine.

To apply security I have set up a common workgroup and have achieved the
required access to each database individually, but 'GetObject' no longer
works. Does anybody know how I can run an instance of the second database
from the first when secured through a common workgroup? Combining the
databases into one is not an option.

On Thu, 24 Jan 2008 01:33:00 -0800, Graham Masters
<(E-Mail Removed)> wrote:

One option might be to use the Shell function to run msaccess.exe with
a command line including /wrkgrp, /user, /pwd, and most notably /x to
run your macro.

-Tom.


>I have two large complex Access 2003 databases where one uses 'GetObject' to
>open the second and then I run a macro within it. This works fine.
>
>To apply security I have set up a common workgroup and have achieved the
>required access to each database individually, but 'GetObject' no longer
>works. Does anybody know how I can run an instance of the second database
>from the first when secured through a common workgroup? Combining the
>databases into one is not an option.

Thanks Tom, I've now succesfully got to the database. Would you know by
chance the syntax for the inclusion of the macro run command?

"Tom van Stiphout" wrote:

> On Thu, 24 Jan 2008 01:33:00 -0800, Graham Masters
> <(E-Mail Removed)> wrote:
>
> One option might be to use the Shell function to run msaccess.exe with
> a command line including /wrkgrp, /user, /pwd, and most notably /x to
> run your macro.
>
> -Tom.
>
>
> >I have two large complex Access 2003 databases where one uses 'GetObject' to
> >open the second and then I run a macro within it. This works fine.
> >
> >To apply security I have set up a common workgroup and have achieved the
> >required access to each database individually, but 'GetObject' no longer
> >works. Does anybody know how I can run an instance of the second database
> >from the first when secured through a common workgroup? Combining the
> >databases into one is not an option.
>

On Thu, 24 Jan 2008 08:48:03 -0800, Graham Masters
<(E-Mail Removed)> wrote:

Not sure what you mean. /x <your_macro> will run your macro at startup
time. There is a page about the Access command line in the Help file.

-Tom.


>Thanks Tom, I've now succesfully got to the database. Would you know by
>chance the syntax for the inclusion of the macro run command?
>
>"Tom van Stiphout" wrote:
>
>> On Thu, 24 Jan 2008 01:33:00 -0800, Graham Masters
>> <(E-Mail Removed)> wrote:
>>
>> One option might be to use the Shell function to run msaccess.exe with
>> a command line including /wrkgrp, /user, /pwd, and most notably /x to
>> run your macro.
>>
>> -Tom.
>>
>>
>> >I have two large complex Access 2003 databases where one uses 'GetObject' to
>> >open the second and then I run a macro within it. This works fine.
>> >
>> >To apply security I have set up a common workgroup and have achieved the
>> >required access to each database individually, but 'GetObject' no longer
>> >works. Does anybody know how I can run an instance of the second database
>> >from the first when secured through a common workgroup? Combining the
>> >databases into one is not an option.
>>

Thanks Tom, very helpful - problem now solved.

"Tom van Stiphout" wrote:

> On Thu, 24 Jan 2008 08:48:03 -0800, Graham Masters
> <(E-Mail Removed)> wrote:
>
> Not sure what you mean. /x <your_macro> will run your macro at startup
> time. There is a page about the Access command line in the Help file.
>
> -Tom.
>
>
> >Thanks Tom, I've now succesfully got to the database. Would you know by
> >chance the syntax for the inclusion of the macro run command?
> >
> >"Tom van Stiphout" wrote:
> >
> >> On Thu, 24 Jan 2008 01:33:00 -0800, Graham Masters
> >> <(E-Mail Removed)> wrote:
> >>
> >> One option might be to use the Shell function to run msaccess.exe with
> >> a command line including /wrkgrp, /user, /pwd, and most notably /x to
> >> run your macro.
> >>
> >> -Tom.
> >>
> >>
> >> >I have two large complex Access 2003 databases where one uses 'GetObject' to
> >> >open the second and then I run a macro within it. This works fine.
> >> >
> >> >To apply security I have set up a common workgroup and have achieved the
> >> >required access to each database individually, but 'GetObject' no longer
> >> >works. Does anybody know how I can run an instance of the second database
> >> >from the first when secured through a common workgroup? Combining the
> >> >databases into one is not an option.
> >>
>