By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,967 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,967 IT Pros & Developers. It's quick & easy.

User-Level Security

P: 20

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.
Aug 8 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,679
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:
    Expand|Select|Wrap|Line Numbers
    1. "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:
    Expand|Select|Wrap|Line Numbers
    1. "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Databases\Secured\Northwind.mdb" /wrkgrp "C:\Databases\Secured\Secure.mdw"
Aug 8 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.