Automatically setting the .mdw path

[ftrujill0]

Is there any way to have the db automatically point to the correct path that
the security.mdw file resides in rather than having the user manually join
the workgroup the first time they use the database? thanks in advance

 

[Joan Wild]

Instead of manually joining the mdw, use a desktop shortcut. Leave them
joined to the system.mdw.

You wouldn't want to join the secure mdw anyway, as they'll then have to
login to every database, not just the secure one.

The target of the shortcut would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

 

[Jeff Conrad]

The best way to do this is to have your users always be joined to their
default system.mdw workgroup file. If they wish to use your secured
database then you create a custom desktop shortcut for them with
the following syntax:

"Full path to msaccess.exe here" "Full path to file here" /wrkgrp
"Full path to workgroup file here"

That should all be on one line in the Target area.

This will tell Access to use *that* specific workgroup file for
*that* specific session on *that* specific database.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[ftrujill0]

Jeff and Joan. Thank you both. Please forgive my ignorance but will this
work on a networked Front End/ BE database? The FE is stored on each users
pc and the BE is stored out on the network. Can I set one custom FE shortcut
and distribute that shortcut with a copy of the front end db to each user? I
haven't researched how to create a custom shutcut yet but is it created the
same way you create a normal shortcut?

Thanks again. you probably hate us newbies.

P.S. J & J - I have found several of your past postings to other users very
useful and helpful. Joan I have seen your name posted on several access user
webpages.

 

[Joan Wild]

Jeff and Joan. Thank you both. Please forgive my ignorance but will
this work on a networked Front End/ BE database? The FE is stored on
each users pc and the BE is stored out on the network. Can I set one
custom FE shortcut and distribute that shortcut with a copy of the
front end db to each user?

Theoretically, yes. As long as everyone has a typical installation of
Access, and they put the frontend in the same folder/path on their PC's,
then yes.

But if someone has installed Office to a different folder, or they put the
frontend in a different location, then they'll need to modify the target to
reflect the location of those files.

I haven't researched how to create a
custom shutcut yet but is it created the same way you create a normal
shortcut?

Sure. Just locate msaccess.exe on your machine, right click it and send to
desktop. Then right-click the shortcut on the desktop and modify the target
to add the "path to mdb" /wrkgrp "path to mdw" parts.

Thanks again. you probably hate us newbies.

Nope. We've all been one.

 

[Jeff Conrad]

in message:

Jeff and Joan. Thank you both. Please forgive my ignorance but will this
work on a networked Front End/ BE database? The FE is stored on each users
pc and the BE is stored out on the network. Can I set one custom FE shortcut
and distribute that shortcut with a copy of the front end db to each user? I
haven't researched how to create a custom shortcut yet but is it created the
same way you create a normal shortcut?

If everyone has the same installation path for the Access executable, the
FE is stored in the same folder on each user's PC, and the mapped drives
to the BE are the same (UNC would be better), then yes, one shortcut
fits all.

Thanks again. you probably hate us newbies.

Nope.
We'd all hate ourselves at some point in time then.
;-)

P.S. J & J - I have found several of your past postings to other users very
useful and helpful. Joan I have seen your name posted on several access user
webpages.

Thanks.