ACCESS FEED: Re: [MS_AccessPros] Security

Selasa, 17 September 2013

Re: [MS_AccessPros] Security

Sarah-

You need to secure the .mde so that it opens only in the secured workgroup. You need to remove all authority to the Admin user and the Users group.

John Viescas

Sent from my iPad

On Sep 17, 2013, at 18:05, sarahk@schemesoftware.com wrote:

I currently have a split database in Access 2003, every user has their own front end and they share one back-end. In the shortcut that opens the database, their is a reference to a workgroup that prompts for user name and password before they can open the application. However if the user modifies the shortcut and removes the reference to the workgroup, they can bypass the security. How do I prevent this?.

The shortcut looks currently like this:

'"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "G:\demo\demo.mdw" "G:\demo\demouser1.mde" /CMDG:\demo\demo.MDB'

If they user changes it to this, they can bypass 'security':

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "G:\demo\demouser1.mde" /CMDG:\demo\demo.MDB'

How can I prevent this?.

As always thanks in advance for all your input.

Sarah

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic