Auto join to MDW

[Pendragon]

From info on other posts, I have set my shortcut to the following:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\Database\FSCorp.mdb" /wrkgrp "p:\DataWH\FSCorpUsers.mdw"

where p is our network drive.

Opening the database through the shortcut did in fact get the login prompt.
However, after opening the database, I went to TOOLS - Security - Workgroup
Administrator to see if in fact it joined the workgroup. What was listed was
the default access workgroup and not the workgroup file specified in the
shortcut.

So I am looking for confirmation that the shortcut is in fact connecting my
db to the workgroup file I have created for the db, and also any
explanation/information as to why the Tools-Security settings would not show
the correct workgroup file.

Thanks.

 

[Armando Blanco]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Armando Blanco
Microsoft MVP

 

[Granny Spitz via AccessMonster.com]

However, after opening the database, I went to TOOLS - Security - Workgroup
Administrator to see if in fact it joined the workgroup.

This tool reads the Windows registry, so it only shows the path and file name
of the workgroup file you are currently joined to, not which workgroup file
is being used for the *current session.*

What was listed was
the default access workgroup and not the workgroup file specified in the
shortcut.

As it should. Your shortcut tells the operating system, "Open *this* MDB
file with *this* executable while joined to *this* workgroup for *this*
session only," and then supplies the paths and file names and command line
switch needed. It doesn't matter what workgroup file you're currently joined
to before you run this shortcut, because when the DAO workspace (the session)
opens, it will use the workgroup file you designated in the shortcut. And
you don't have to rejoin a workgroup after the session closes, because the
workgroup you are joined to (as saved in the Windows registry) never changed.

This shortcut is a handy technique to use, because you never have to worry
about which workgroup the user is currently joined to and has to be rejoined
to after the secure database is no longer being used. You just need the
database to be opened using the designated workgroup, which the shortcut does.
Quite conveniently.

So I am looking for confirmation that the shortcut is in fact connecting my
db to the workgroup file I have created for the db

Press <CTRL><G> to open the immediate window and type:

?DBEngine.SystemDB

and then press <ENTER>. It will show you the workgroup joined to for the
*current session,* regardless of what workgroup file is saved in the Windows
registry.

 

[Pendragon]

Thank you very much for the detailed explanation - that is truly appreciated.
I ran the immediate window and it in fact (surprise!) does show that I am
connected to the workgroup file I need to be connected to.

On a separate note - I want to show that your post helped me, but when I
double click on your response, I get a new window that only shows the initial
post and whatever of the second thread that will fit in the window; there is
no scroll bar for me to scroll to your post (or any other posts below yours
if should there have been any) and to click on the Yes button about the post
being helpful. Any ideas on why my internet explorer window might be doing
this? I did notice that in opening the thread after the double-click, the
page of threads initially displays but then is reformatted and resized with
the newsgroups listing on the left and the thread on the right (but no scroll
bar).

Is this a Microsoft formatting issue on the webpage, or is my Internet
Explorer setting messed up?

 

[Granny Spitz via AccessMonster.com]

Thank you very much for the detailed explanation

You're welcome, hon. I'm glad you found the information you needed.

On a separate note - I want to show that your post helped me,

That's very thoughtful of you! Thank you very much.

when I
double click on your response, I get a new window that only shows the initial
post and whatever of the second thread that will fit in the window ...
Is this a Microsoft formatting issue on the webpage, or is my Internet
Explorer setting messed up?

I don't think it's being caused by your browser. I think the Microsofties
may be tweaking their Web site again so that it works better in the next
version of Internet Explorer. See if this link shows the Yes and No buttons
on the bottom right with my earlier post highlighted:

http://www.microsoft.com/office/com...634fcb-3d7d-449a-820e-77a16ca504d8&sloc=en-us

 

[Pendragon]

I clicked on your link - yes, I can see the Yes/No. I take it an upgrade is
in order for me?

 

[Granny Spitz via AccessMonster.com]

I take it an upgrade is
in order for me?

Not just yet. Microsoft is still testing Internet Explorer 7 RC1. The final
release version is scheduled to be available to the public later this year,
reportedly as a Windows automatic update.