Access Workgroups

[Graham Masters]

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.

 

[Tom van Stiphout]

On Thu, 24 Jan 2008 01:33:00 -0800, Graham Masters

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.

 

[Graham Masters]

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]

On Thu, 24 Jan 2008 08:48:03 -0800, Graham Masters

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.

 

[Graham Masters]

Thanks Tom, very helpful - problem now solved.

On Thu, 24 Jan 2008 08:48:03 -0800, Graham Masters

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.