mdw file location for split dbs

[QB]

This is a ,sort of, follow-up post to my previous security question
(http://www.microsoft.com/office/com...&p=1&tid=0df96534-fdd0-4b37-a907-0ad32370e1a1).

Assuming another developer setup a split db where he setup the computer's
default mdw to use the database's mdw, so that the database mdw gets
installed on every pc locally. Can this cause a problem in a multi-user
environment?

Let me explain a little more:
Typically, you place the back-end and the database on the central server and
then deploy the front-end on each user's desktop pc. Then in your shortcut
you reference the mdw and the mde (or mdb).

In this case that I am trying to fix a performance issue, they placed the
back-end in a central location, but then deployed the front-end and the
database mdw on each user's desktop pc. They setup the mdw as access'
default mdw so they don't need to specify the /wrkgrp in the shortcut.

Could this setup explain a performance hit when a 2nd user logs into the db?
Or is this an acceptable setup?

Thank you

QB

 

[Tom van Stiphout]

On Wed, 17 Mar 2010 16:48:01 -0700, QB <[email protected]>
wrote:

I would keep the workgroup file on the server, perhaps in the same
folder as the back-end. Then use Tony's excellent program
www.autofeupdater.com to deploy the front-end. The tool will also
create a shortcut on the user's desktop, including the /wrkgrp switch
if needed (see www.autofeupdater.com/pages/settings11.htm). And please
do consider the voluntary license.

-Tom.
Microsoft Access MVP

 

[david]

The MDW is a database of user names and passwords. If it
changes frequently, and you need to be able to get the current
list of users and passwords, it should be on a server.

If you are just using the default access login, it only has the
default name "admin" and default password "", and the
default groups "users" "admins" etc.

If it is on the server, it can be shared by all users. Since
users only typically use it once, at login, that is not a problem,
but if you are doing development, it can be locked, which
can lock everyone out. But that only mean that you should
use a separate copy when doing development.

If it is shared on the server, it can be a performance hit,
but only when it is used, which is typically only when the
user starts Access.


Using a local copy of the database cannot cause a performance
hit and cannot cause locking problems, but, as with any database,
if you use a private copy you don't have any changes made by
other users.

Sometimes when you deploy applications to users, you deploy
them to the users home drive. The home drive may actually
be a network drive. If you deploy a personal copy of the MDW
to each user, but then put it in the users area of a network
drive, you have the worst of both speed and distribution problems.

But even that shouldn't matter, because typically the MDW is
only used when the user is starting Access.

(david)

 

[tom_willpa]

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com