Loading access using a generic acct

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

Guest

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
 
An easy way to stop people viewing or changing the internal design &
coding of forms, reports, & modules, is to provide a so-called MDE
version of the database. Check F1 help for MDE.

HTH,
TC
 
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)
 
Back
Top