|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
shortcut just to accessAll the examples of shortcuts using workgroup files I have seen involve an
existing database. I thought though that to be the owner of a database you have to create it whilst logged on to the workgroup file you want to use to secure it, so is it possible to just open Access with no database, logging onto a workgroup, and then create a new database? S wrote:
> is it possible to just open Access with no database, logging Yes, as long as your version of Access has the Workgroup Administrator built> onto a workgroup, and then create a new database? in. Just open Access and select Tools | Security | Workgroup Administrator. When the dialog window pops up, select the "Join..." button, then navigate to and select the workgroup file you want. Once you've joined your secure workgroup, create a new database by selecting File | New and follow the prompts. When you're done creating your database, importing or creating the objects, you'll need to rejoin the default workgroup again so that you don't get prompted for user name and password every time you want to open even the unsecured databases. But honestly, it's just easier to create a shortcut that joins you to the secure workgroup for the current session and then opens Access for you. The target for your shortcut would look like this (if you installed in the default directory with Access XP), which is all one line: "C:\Program Files\Microsoft Office\OFFICE10\MSACCESS.EXE" /wrkgrp C:\Secure\ Secure.MDW -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 Thanks for your reply. I had tried the shortcut as you described but I think
there must have been something wrong with the name of the workgroup file, which I had copied from another computer using a floppy, because it didn't work, but when I created a new workgroup file the shortcut worked. Thanks for the other infomation though, it is useful to know about. S. Show quoteHide quote "Granny Spitz via AccessMonster.com" wrote: > S wrote: > > is it possible to just open Access with no database, logging > > onto a workgroup, and then create a new database? > > Yes, as long as your version of Access has the Workgroup Administrator built > in. Just open Access and select Tools | Security | Workgroup Administrator. > When the dialog window pops up, select the "Join..." button, then navigate to > and select the workgroup file you want. > > Once you've joined your secure workgroup, create a new database by selecting > File | New and follow the prompts. When you're done creating your database, > importing or creating the objects, you'll need to rejoin the default > workgroup again so that you don't get prompted for user name and password > every time you want to open even the unsecured databases. > > But honestly, it's just easier to create a shortcut that joins you to the > secure workgroup for the current session and then opens Access for you. The > target for your shortcut would look like this (if you installed in the > default directory with Access XP), which is all one line: > > "C:\Program Files\Microsoft Office\OFFICE10\MSACCESS.EXE" /wrkgrp C:\Secure\ > Secure.MDW > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 > > S wrote:
>Thanks for your reply. I had tried the shortcut as you described but I think You're welcome, hon. Glad to know the new workgroup shortcut is working for>there must have been something wrong with the name of the workgroup file, >which I had copied from another computer using a floppy, because it didn't >work, but when I created a new workgroup file the shortcut worked. Thanks for >the other infomation though, it is useful to know about. you. Thanks for the feedback. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 |
|||||||||||||||||||||||
Other interesting topics