shortcut just to access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All 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 said:
is it possible to just open Access with no database, logging
onto a workgroup, and then create a new database?
Click to expand...

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
 
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.
 
S said:
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.
Click to expand...

You're welcome, hon. Glad to know the new workgroup shortcut is working for
you. Thanks for the feedback.
 
Back
Top