C# form with Access database and access security permissions

Posted on 2010-01-09
Medium Priority
Last Modified: 2013-12-17
I am creating a micrososft database and am going to use security- ( access 2003)-
If I create a C# form for users to work with database - can I still use the microsoft access security to protect data I don't want to be seen?
thank you
Question by:davetough
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 26274954
You can - but if you're not working directly in the Access interface, then ULS can be somewhat of an overkill. In your C# application, you can simply use queries to limit what users see - they wouldn't be able to direclty access the Tables from your application, so you wouldn't run the risk of users stumbling on your tables.

Of course, users could get to the backend, if they find it. In that case, you would prefer to have some sort of security in place, and ULS could certainly qualify for that.

Author Comment

ID: 26275220
Thanks LSM- I wonder if I could ask you one more question-
If I put an access database on a network running Windows 2003 server. Is there anyway the admin can lock the folder the access database is in? and would that then mean that anyone with admin permisson could get into folder- or could it be locked only to be able to be opened by a a certain user?
I know this may be server question-
and can a .net app still interface with a database locked in a folder.
thanks -
LVL 85
ID: 26275244
No - users must have at least Modify permissions on the Folder hosting the database.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses
Course of the Month10 days, 23 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question