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

MS Access User permissions

P: 2
I am newb to this forum and MS Access. I am just wondeing if someone can help me with the read, write, update, delete permissions. I know you can do it using a wizard in MS Access, but its not an efficient way of doing things.

I have created a login table

EmpID Permissions
1234 Read
1235 Write
1236 Update
1237 All

Now whenever an employee want to insert, delete, read or delete something from table i want to check his permission level from the login table before giving him access to the table.

How would i do that on database level without using the wizard?

Can we create triggers in MS Access too. If so what would be the syntax of SQl?

Thanks in anticipation
Jun 4 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,

In fact in MsAccess Doesn't have triggers that you can use as you do in MSSQL or in the others SDA!

In access you can define user groups, users and user and group permissions!

But reelly I don't think that this security feuaters in MS Access garantee your data security!

If your organize your own security using the tables and VB and the properties in the queries and forms maybe your results will be bigger than if you use MS Access security!

When you retrieve information from your queries, you do updates, appends, deletions there you can use something like the triggers...

When you open an active query you have to assign the rights that the user have for this query... You can habit the inserts, the deletions, the edits, maybe for the respective user to view the query :)

In this forum I've written about the functions to use about!
Sep 6 '06 #2

Post your reply

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