March 21, 2006 at 3:25 am
Hi ,
I'm trying to secure my access database using access 2000.
I have created groups and permissions and made a copy of the mdw fie. I have joined it so it to the new file (mysystem.mdw)
First of all when I use the wizard to secure the objects it doesn't carry out the full load. Therefor no report is created. WHY is that ?
Also if I open up another database in access it prompts me for a user name and permission. Is there a way this prompt only comes up when this particular database is open. Meaning unique to this database.
Regards
Ritesh
March 21, 2006 at 9:04 am
Ritesh,
The best way to add security to an existing database is to set up a BLANK database with security (joined to the appropriate mdw) then to import your objects from the existing database. You need to be sure to be logged on as an administrator when you do the import, and don't forget to do toolbars & import specifications, if you're using them.
Once you've joined a particular MDW, you are permanently in it until you join another mdw. Therefore, when you joined your "mysystem.mdw", you were still using it when you went the the other database. That's why you were prompted for username and password. To stop using your "mysystem.mdw", you rejoin the system.mdw that came with Access. In older versions of Access, the file was in System32, in newer versions it is in the Documents And Settings for the appropriate user, somewhere under Application Data.
To get around this, for USERS only, create shortcuts passing the workgroup. Here's an example of how the shortcut needs to be set up (see the shortcut's properties), notice how the full path of Access, the mdb AND the mdw are passed:
"C:\Program Files\Microsoft Office 2002\Office10\MSACCESS.EXE" "C:\BSoft\BSoft.mdb" /wrkgrp "C:\BSoft\Secured.mdw"
Be forwarned: If you are doing any more development on this database, you need to JOIN the mdw and not use the shortcut -- otherwise your permissions will be goofy on any new objects you create.
Thanks,
Metra
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply