[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