Mcgillivray, Donald [ITS]
donald.a.Mcgillivray at mail.sprint.com
Thu Jan 15 12:15:24 CST 2004
John, Is it possible that you're seeing only part (the last part) of the command line in the shortcut? The syntax for passing the workgroup on the command line is: Path to msaccess.exe, followed by path and filename of target mdb, followed by the workgroup switch (/wrkgrp), followed by the path and filename of target mdw. For example: "c:\program files\msoffice\office\msaccess.exe" "c:\MyDatabases\target.mdb" /wrkgrp "c:\MyDatabases\target.mdw" Note that quotes around the segments are only critical if there are spaces in the strings (doesn't hurt to include them, though), and that the positions of the path to the mdb and the workgroup segment are interchangeable. Thus, if the other programmer had put the workgroup segment before the mdb segment, you might be seeing just the tail end of the one followed by the entirety of the other. Hope this helps. Don McGillivray -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Thursday, January 15, 2004 9:47 AM To: accessd at databaseadvisors.com Subject: [AccessD] MDW file This group has helped me so much over the past two years. My confidence has increased 1000%, which I attribute directly to my involvement with this list. Just yesterday, my boss made some crack about an external programmer that they have used...basically saying that if I get as good as him I could do what he does (he is currently taking a year off and traveling the country in an RV)...and for the first time, I stood up and said, "I am just as good, if not better, than [that guy]." Anyhow, now that I have explained how 'good' I have become, I was thrown a twist. Because this guy is out of town, he cannot respond to a call that they have regarding a program he wrote. It needs to be placed on the desktops, of another department. "No problem," I said, "I can handle it." But I notice in the shortcut that exists, in the original department, it uses an .MDW file in the target line (ms.mdw" "c:\program files\cms\cmssecure.mdb"). I just called to verify this line, because I thought that at least a "c was missing from the front...I don't get the one quote mark. I have never used workgroup features of Access, and I really don't plan to. What do I need to do to set this up? Thanks! John W Clark John W. Clark Computer Programmer / Asst. Network Administrator Niagara County Central Data Processing _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com