workgroup settings copied over to all my other databases

[Tine]

Good afternoon

For training purposes I have created a database called
training_database.mdb. I have copied the database five times. And in each
of those five versions I have deleted for instance a form so that pupils
would be able to create their own form.

At the end of all this, I have created a workgroup for the
training_database.mdb. Now when I open one of the copies, I get prompted for
a password as well, which was not the aim because pupils should be able to
access forms in design mode. After having read the following article
http://www.techsupportalert.com/pdf/t1526.pdf, I conclude that I have set the
new workgroup file (security1.mdw) as default. Therefore I get prompted for
a password even when I try to create a blank database. Normally for a blank
database the system.mdw should be used.

I have solved my problem by creating a new workgroup without creating
groups. So everyone is now administrator of the database.

However if I want to secure the database by using the user-level security
wizard, should I not tick the option to make the new workgroup the default
one? If I put the secured database then on a shared networkdrive, do I need
to save the mdw or workgroup file onto it? Will other users get prompted
according the newly created workgroup then?

thank you for your information

 

[Lynn Trapp]

As a former Access trainer myself, I would think you would want your
students to see, and implement, the full effect of User Level security. That
would include being prompted for a username and password. Let me suggest
that you get a copy of the Security FAQ, read it several times, then
practice following it to the letter before you try introducing the concept
to your students. There is a link to it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[TC]

As a rule, you should always leave the default workgroup file as the
current default (as it were!).

When you want to open a secured database, you should do so via a
shortcut of the following form (all on one line):

"full path to msaccess.exe"
"full path to mdb/mde file"
/wrkgrp "full path to securing mdw file"

Then, Access uses the specified workgroup file for that single open
only.

HTH,
TC