Re: Loading access using a generic acct
- From: "david epsom dot com dot au" <david@epsomdotcomdotau>
- Date: Wed, 14 Dec 2005 09:01:23 +1100
Yes, you can create a shortcut to msaccess.exe with /wrkgrp and
/user and /pwd command line options after msaccess.exe.
But a better way is to create a new 'design' user and workgroup,
and use that user to create a new copy of the database in which
the default ('admin') user does not have design permission on
any of the tables or queries.
Then just let all the other users use the default ('admin') user.
No need to use a different generic name at all.
(david)
"danlin99" <danlin99@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4F032D33-D15C-4665-95F1-A184E897EE00@xxxxxxxxxxxxxxxx
>I have a dbase that will be use by all employees in the company but still
> need to create a group acct for all users so no one can view or change the
> codes and db objects designs. Is there a way that when a user click on
> the
> db shortcut that it will automatically supply the generic username/pwd and
> automatically launch the application. I want to make it easy for everyone
> especially those that have individual Access acct for other dbases. I
> know
> how to do it using the DOS prompt like the one below (username:Access_MIS,
> no
> pwd) but how do I do it within windows. Thanks in advance.
>
> c:
> CD\Program Files\Microsoft Office\Office
> Msaccess.exe \\Everest\public\db_acl\Access_MIS\MIS_Request_Tracking.mdb/x
> autoexec
.
- Prev by Date: Re: Access Security Training
- Next by Date: Re: renamed mdb > dat > email with hotmail > now I can't open it
- Previous by thread: Re: Loading access using a generic acct
- Next by thread: Re: Can I load my genuine windows XP onto pc and laptop. thanx
- Index(es):
Relevant Pages
|
