Hi All
I have a project that I have spent a reasonable amount of time on that I am hoping to replace an excel spreadsheet that is currently in use.
I was wondering if there is an easy way to add say 3 users to the database that have the following access privs.
Me - Complete access - to design etc
Full data access - Able to update records or create new records
New data access - Able to put new records in but not update old or delete records
I have tried the access security wizard but with no love there or at least it does not seem to be doing what i am after.
Any help would be appreciated
Rey
See this
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Here is another resource for setting up levels of security.
http://www.mrexcel.com/forum/showthread.php?t=248191
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks