DB security?

[amromahran]

Hello,
1) I have Db with access2000 on a general PC that many users use it.
2) I make a workgroup for my DB with its usres, and return the default workgroup file to be active because as I told before there is other usres use the PC and access to make other Dbs.
3) I make a shortcut from access2000.exe and write a command to open my DB with my workgroup file.
4) To open my DB, I click on the shortcut to open with the permissions in the work group file.

the problem is :
when double click dircetly on the DB file, it is open with the default workgroup file without any security.

how to solve this problem?

[Mas1]

In the path of the shortcut
You need to include 3 pieces of info
1) the path where msaccess.exe is located
2) the path where the wrkgrp is located And
3) the path where the db is located

If you leave off #3 the users will be able to open Access and choose the db without security

Hope this helps

[Mas1]

I forgot to mention that you must also run the wrkgadm.exe usually located in the C:\Program Files\Microsoft Office\Office\1033 directory so that each time Access is opened it will require a wrkgrp association

[amromahran]

thanks Mas1, but :
There is two problems :
1) if anyone make a copy of my DB file (mydb.mdb) to another PC and double click directly on it, it will open with the default workgroup file without any security.

2) anyone can run the wrkgadm.exe and change the active wrkgrp to the default (system.mdw) so that he can double click on the DB to open without any security.

Conclusion :
I want to write VBA code inside my DB file itself state that (On the db file open; use the workgroup file located in ……. With its permissions, if cann’t find the wrkgrp file; quit from the program). How I can write something like that??

[Gurbuly]

You can't write as per your conclusion as the db is opened before your code is read which kinda defeats the object.

If I read you right, you have a new work group account with users and security permissions on your db? So if your db is double clicked on another pc it uses the locally installed/default workgroup file instead of required workgroup file

The default workgroup uses the user name Admin account to open the db. So, remove the privileges for admin from within the security settings on your db. Before doing so, set up a new account in your db's workgroup file in the admins group with the appropriate privileges/permissions and make sure this account has complete access before removing the admin account. Take back up copies of the db and workgroup files first!