[AccessD] MDW ByPass Surgery, Post Op

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



More information about the AccessD mailing list