CODEWITHSUNDEEP
databasems-access
Mostafa Abbas
Mostafa Abbas

Reputation: 47

Provide security standards for ms access database

Since I am going to ask simple question any help will be appreciated. I went through SQL tutorial almost everything including (DDL, DML), however, now I have to design a library management application and found that I need to include security such as Administrator, Employee. I searched the Internet and found that (DCL) is the way to do that My question :) 1) since I am using ms access, is (DCL) option in it?if not how to apply security in ms access

Upvotes: 2

Views: 113

Answers (2)

Nick.Mc
Nick.Mc

Reputation: 19204

No, DCL is not an option in MS Access.

When you are researching things like this, keep in mind that a lot of generic database concepts have limited application in MS Access because MS Access does not provide many features of advanced database management systems.

If you have chosen MS Access as your platform, try to read only MS Access based sources of information, not generic database information. Otherwise you'll get confused.

Here are some examples of implementing security in MS Access

I know link based answers are not an answer but this may help

  • Using windows login, so no extra login is required

http://www.blueclaw-db.com/download/access_security_alternative.htm

  • Native MS Access security - do not use this, it's too complicated and probably not supported any more

https://www.thoughtco.com/microsoft-access-user-level-security-tutorial-1019981

  • Some other suggestions:

How to implement user-level security in Access 2007

Upvotes: 1

ashleedawg
ashleedawg

Reputation: 21639

Your question isn't clear as to what exactly you're trying to do.

If you have an Access DB with a connection to a SQL Server, you can run DCL commands via VBA SQL calls (not from the query window) to apply user control to the SQL Server.

However if you're asking about user control for an MS Access front-end, DCL does not apply, and furthermore, your options are very limited (if any serious level of security is required).

Friends and I use to race to see who could "hack" past MS Office security the fastest... as in, one to two minutes. Nowadays, Microsoft doesn't bother including the features.

You could try using the older .MDB file format, and applying Access User Level Security, as outlined in the Access Security FAQ: ULS was removed from the newer .ACCDB file format.

Recognize, though, that Access security definitely isn't unbreakable. If there's a need for strong security, you'd probably be better off putting your backend database into SQL Server.
(Source)

If you want to learn about Access, I'd suggest you do a couple Access tutorials (not SQL). The two are related but far from interchangeable, kind of like how VB and VBA are related but not interchangeable.

Upvotes: 1

Related Questions