|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Auto join to MDW"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. 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 Show quoteHide quote "Pendragon" <Pendra***@discussions.microsoft.com> wrote in message news:B89F81A8-2C80-4FD1-9064-A19C3B7E3913@microsoft.com... > 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. Pendragon wrote:
> However, after opening the database, I went to TOOLS - Security - Workgroup This tool reads the Windows registry, so it only shows the path and file name> Administrator to see if in fact it joined the workgroup. of the workgroup file you are currently joined to, not which workgroup file is being used for the *current session.* > What was listed was As it should. Your shortcut tells the operating system, "Open *this* MDB> the default access workgroup and not the workgroup file specified in the > shortcut. 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 Press <CTRL><G> to open the immediate window and type:> db to the workgroup file I have created for the db ?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. 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? Show quoteHide quote "Granny Spitz via AccessMonster.com" wrote: > Pendragon wrote: > > 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. > > -- > Message posted via http://www.accessmonster.com > > Pendragon wrote:
> 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 I don't think it's being caused by your browser. I think the Microsofties> 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? 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/community/en-us/default.mspx?dg=microsoft.public.access.security&mid=bc634fcb-3d7d-449a-820e-77a16ca504d8&sloc=en-us -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 I clicked on your link - yes, I can see the Yes/No. I take it an upgrade is
in order for me? Show quoteHide quote "Granny Spitz via AccessMonster.com" wrote: > Pendragon wrote: > > 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/community/en-us/default.mspx?dg=microsoft.public.access.security&mid=bc634fcb-3d7d-449a-820e-77a16ca504d8&sloc=en-us > > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 > > Pendragon wrote:
> I take it an upgrade is Not just yet. Microsoft is still testing Internet Explorer 7 RC1. The final> in order for me? release version is scheduled to be available to the public later this year, reportedly as a Windows automatic update. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 
Other interesting topics
|
|||||||||||||||||||||||
