Restricting a workgroup information file to only one project?

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

I have designed a database which a I would like to distribute to other persons,
who not are part of my network, and I want to prevent them from making any
changes in the design. If I'm creating a new workgroup
information file and givs certain permissions for users, this file seems to be
the current workgroup information file for all the Access databases om my
computer, even those who I don't want to secure. Can I in some way restrict a
certain workgroup information file to only refer to one specific databasefile,
and leave the rest to the original default workgroup information file? And what
happens when I distribute my application to other computers? I guess the new
workgroup information file has to follow, but what impact will it bring to the
other computer? Or should this task be done in quite another way?
 
If you only want to prevent them changing the design of forms, reports &
modules, just create an MDE version of the database.

If you want to prevent thm changing the design of tables as well, you
could< do this by distributing a custom workgroup information file, or
Click to expand...
there is another (more complex) way which would achieve the same result
without< the need to distribute a custom workgroup file.
Click to expand...

But before you go any further, you really need to go back & study the Access
Security FAQ. This will explain some basic facts, such as, how Access
decides whch workgroup file to use when you open a database. (Answer: it
uses the current default workgroup file for your PC, unless you explicitly
tell it to use a different one, by creating a shortcut using the /wkgrp
switch. Googling this group for "/wkgrp" will doubtless find millions of
hits.)

HTH,
TC
 
Thanks for you answer.
Where do I find the Access Security FAQ. I'm new in this group. I like to learn
more of this "another more complex way".
Robbie
 
for another appoach to security besides the FAQ, see the documentation
in the website in my signature

Thanks for you answer.
Where do I find the Access Security FAQ. I'm new in this group. I like to learn
more of this "another more complex way".
Robbie
Click to expand...


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
 
Back
Top