 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / January 2008Access Workgroups
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. 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. [quoted text clipped - 4 lines] >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? > 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 [quoted text clipped - 10 lines] > >from the first when secured through a common workgroup? Combining the > >databases into one is not an option. 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? [quoted text clipped - 13 lines] >> >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. > 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. [quoted text clipped - 18 lines] > >> >from the first when secured through a common workgroup? Combining the > >> >databases into one is not an option. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.