John Clark
John.Clark at niagaracounty.com
Thu Jan 15 14:18:37 CST 2004
When I comes to my users, I will not claim that anything is 'impossible.' However, I did call out to the department where it is installed and walked a user through the process of getting to the properties window and had her tell me exactly what it said. I even questioned that there was the single quote mark. This was actually one of my better users too. I should have gone to their office, but it is across town...not really that far, but it is bitter cold her today and there is quite a bit of snow too (I know...wahhhhhh!) I just recreated the shortcut and it finally presented me with a login window. I called to get a login name and apparently the programmer left no way for them to add users...or delete users...real secure when you cannot remove a user from the system after they are fired...duh! Anyhow, the whole reason I am doing this is because I need to add a bunch of new users, and delete another bunch. I work for a county government and the republicans just took over power from the democrats, and this means all patronage positions are taken away from the departing party and given to the new ones (who cares if their good at their jobs or not, as long as they're part of the majority party). This means all new attorneys in the county attorney's office, and now I don't seem to be able to add them. Ideas?! Thanks for the help so far though! John W Clark >>> donald.a.Mcgillivray at mail.sprint.com 01/15/04 01:15PM >>> 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com