ULS database example please...
- Thread starter genesis
- Start date
same problem with Genesis. We are hoping to download sample database here in our forum the ULS database so I can study it. i have been studying ULS but i think I can more appreciate studying it when I have an example to follow. would you kindly provide me an example to follow and study. thanks.
HiTechCoach
Well-known member
- Local time
- Today, 09:00
- Joined
- Mar 6, 2006
- Messages
- 4,357
To learn abut security, you need to test it by doing it. It is very difficult to understand how it works by looking at something already created since there really is not a lot you can see.
To learn more, see:
The Microsoft Access Security Apparatus
and
Security paper by Jack MacDonald (EDIT: Updated link)
Note: this is not support in the new 2007 accdb format. ULS is still supported in Access 2007 but only for the old mde databases and derivitives. The accde format does not include ULS capability.
http://office.microsoft.com/en-us/access/HA101662271033.aspx
Essentially Microsoft has decided to discourage the use of ULS as explained here:
http://blogs.msdn.com/access/archive/2005/10/19/access-12-security-model.aspx
"Since JET is a file based database system where users need physical access to the file to operate on their data, the concept of user level security in Jet to assign different levels of user access to the data within the same file was not recommended. To have multiple people use the database but with different data access privileges, the recommended practice was to move this data to a centralized service like SQL server or SharePoint lists. However, Jet has had this feature for some time and it has worked OK for usability and custom navigation scenarios but isn’t recommended for actual security. "
If security is a must for your tables, then I would not use an Access back end, but an SQL server like Microsoft's SQL Server.
To learn more, see:
The Microsoft Access Security Apparatus
and
Security paper by Jack MacDonald (EDIT: Updated link)
Note: this is not support in the new 2007 accdb format. ULS is still supported in Access 2007 but only for the old mde databases and derivitives. The accde format does not include ULS capability.
http://office.microsoft.com/en-us/access/HA101662271033.aspx
Essentially Microsoft has decided to discourage the use of ULS as explained here:
http://blogs.msdn.com/access/archive/2005/10/19/access-12-security-model.aspx
"Since JET is a file based database system where users need physical access to the file to operate on their data, the concept of user level security in Jet to assign different levels of user access to the data within the same file was not recommended. To have multiple people use the database but with different data access privileges, the recommended practice was to move this data to a centralized service like SQL server or SharePoint lists. However, Jet has had this feature for some time and it has worked OK for usability and custom navigation scenarios but isn’t recommended for actual security. "
If security is a must for your tables, then I would not use an Access back end, but an SQL server like Microsoft's SQL Server.
Last edited:
