Nicholson, Karen
cyx5 at cdc.gov
Thu Nov 4 12:08:43 CST 2004
Yeppers. I have met with management and we have decided that the custom .mdw is outdated technology for our purposes. YEAH!!! Now I just have to go point 25 users back to the system.mdw that came with their package and not worry about it. All the security we need is table level and I have cranked that down on SQL server. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, November 04, 2004 12:48 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] MDW ByPass Surgery, Post Op You join a workgroup, whether you realize it or not, when you open Access or when you use the workgroup administrator to join one. By default, the system.mdw on the local machine is the workgroup unless you join another one. Using a shortcut allows you to specify the workgroup on the server for that session without changing the default workgroup. That should solve your problem. Charlotte Foust -----Original Message----- From: Nicholson, Karen [mailto:cyx5 at cdc.gov] Sent: Thursday, November 04, 2004 9:05 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] MDW ByPass Surgery, Post Op That is what I was thinking - why put it on a user's machine? So that makes sense. The backend is now in SQL and the security for the tables is ruled by SQL. I can put something in the start up of the app to identify the lan user id, and if they are not in my group of users, then out they go. So... How does one get rid of the reference to the .mdw once one has been established? If I open up any Access database, this stoopid thing runs. On the web, it is telling me to re-install Access. Must be a better way. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Thursday, November 04, 2004 11:42 AM To: 'Access Developers discussion and problem solving'; Nicholson, Karen Subject: RE: [AccessD] MDW ByPass Surgery, Post Op With no password, if you pass the user name in the command line then the worst you'll have to do is hit enter when the password dialog appears. Not too arduous <g>. There is little point in having the MDW file on the user's machine. If you needed to move them into a different user group you would have to visit the workstation to do that. So the MDW should always be centrally stored, available to all users. But note, the MDW is in fact just a plain ordinary MDB file with a different extension. As such it is subject to all the usual corruption risks, so I should be sure to backup the file at least once every day. If you do get a corruption of the MDW file, usually it is enough to open it with Access (from the File, Open menu) and run a Repair on it. Lambert > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen > Sent: Thursday, November 04, 2004 11:11 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] MDW ByPass Surgery, Post Op > > What would you do if the PWD is null, none assigned in the .mdw? AND... > Is it OK to store the .mdw reference on a shared drive on the network > instead of on an individual PCs folder? > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MG > Sent: Thursday, November 04, 2004 7:27 AM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] .MDW ByPass Surgery > > > Try a shortcut on your desk, (watch for word wrap) viz: "C:\Program > Files\Microsoft Office\OFFICE11\MSACCESS.EXE" > "C:\_MCM\MCMFrontEnd.mdb" /wrkgrp "\\Server\svr-c\MCM\MySystem.mdw" > /USER max/PWD max123456789 > > Regards > Max > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, > Karen > Sent: 04 November 2004 12:13 > To: accessd at databaseadvisors.com > Subject: [AccessD] .MDW ByPass Surgery > > My database is hooked to a .mdw. During the development stage, I want > to open up the database and bypass this nag screen that asks for the > user name > and password. I have been googling, but can't find too much. > I would like the shortcut on my desktop to do it, I think. But at this > point I will do just about anything to disconnect it while I am > developing. Thanks, wise ones. > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004 > > > -- > _______________________________________________ > 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 -- _______________________________________________ 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com