User-Level Security

[weirdguy]

Hello,

I currently use Access 2007 but the access file is in 2003 version as I would like to use the User-Level Security as a Control purpose.

My project is intended to be use by a Single user. I intend to use the ULS as to control what the User able to access and not be able to access. For an example, User had the only permissions to view, update, delete and add records via Forms - but User unable to access (read & edit) Tables, Query. User also unable to access any Module, VBA Coding, Macros and others.

I tried to activate the ULS sucessfully. However, the ULS applied to all access documents. In other words, whenever I opened up other non-related database, Access also prompt me for the login info. Is it suppose to be like this?

I understand ULS is not as secured as it sound, but I would like to see it as a Control purpose only and some forms of copy protection towards my design and coding. Any other ways is welcomed.

[ADezii]

@weirdguy
User Level Security is primarily defined by the Workgroup Information File (*.mdw). You can create Shortcuts to Open Databases either as 'Secured' or 'Unsecured' simply by pointing to different *.mdws. Naturally, the Shortcut itself is not that secure by its very nature.

1. To Open the Unsecured Test Database residing in the C:\Test\ Directory with the Default Workgroup Information File:
   

   "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Test\Test.mdb" /wrkgrp "C:\Test\System.mdw"

   [
2. To Open the Secured Northwind Database residing in the C:\Databases\ Secured\ Directory with a Secured Workgroup Information File:
   

   "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Databases\Secured\Northwind.mdb" /wrkgrp "C:\Databases\Secured\Secure.mdw"