User Security in Access

[Dip]

Hello,

I have around 10 users that use this Access database.
Is it possible to allow only 2 of them to edit or modify the relationships,
about 4 of them to input data only, and the rest to see and export data ONLY.

Thanks in advance.

Dip

 

[a a r o n . k e m p f]

only a retard would try to use Access with 10 users.

move to SQL Server 2005 Express.

-Aaron

 

[John W. Vinson]

Hello,

I have around 10 users that use this Access database.
Is it possible to allow only 2 of them to edit or modify the relationships,
about 4 of them to input data only, and the rest to see and export data ONLY.

Thanks in advance.

Dip

What version of Access?

Access 2003 and previous versions have "workgroup security". This feature was
removed in 2007, however. It's fairly complex, and it can be broken fairly
easily if someone is determined to do so ("locks keep out honest people"); but
if you're just trying to control workflow rather than block determined
hackers, you may want to investigate it.

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

It applies to all versions from 95 through 2003 so don't let the 2000 deter
you. Print it out. Read it carefully. Get a good night's sleep. Read it,
AGAIN, more carefully. Make a backup of your database, and follow the
instructions in the FAQ, step by step, checking them off as you do (I've
secured many databases and still do so!)

I don't often agree with Aaron, but if you really need good data security,
he's right: SQL/Server security is much tighter (and also requires a lot of
careful study and thought to implement).

 

[Tony Toews [MVP]]

only a retard would try to use Access with 10 users.

move to SQL Server 2005 Express.

Absolute rubbish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[aaron_kempf]

no. You are absolutely rubbish.

Only a retard would try to use 10 users in Access in this day and age.

SQL Server is free and it has been for a decade.

MOVEON.ORG

-Aaron

 

[aaron_kempf]

and for the record, half the MVPs admit that there is a real tangible
user limit of about 10 people. Maybe 15. but it sure ain't 20.

We're talkign abotu people entering data-- all day long-- reliably for
a year without problems.
Jet jsut doesn't cut the cheese.

SQL Server works like a charm.

-Aaron