RECORD LEVEL SECURITY

[Bob]

Is it possible to restrict access to records for users. I want them to only
see their own records and not the records of others.

If so would you be able to give me some insight on how you would do that?

 

[Banana]

Well, you could use a query with an appropriate WHERE clause to restrict
rows to only which users are authorized to view/edit.

That will work for keeping honest users honest but if you need something
more than that, I would probably look for a RDBMS backend. With .mdb
format, you have the option of using ULS and running RWOP queries so it
can't be easily edited and requires more technical expertise but ULS &
RWOP queries still could be overcome, hence me suggesting a RDBMS
backend first.

 

[Arvin Meyer [MVP]]

Access, or rather, Jet is an RDBMS. I think what you are referring to is a
server database engine rather than a file database engine. If internal
security is crucial, a server based system, like SQL-Server, is imperative.

That said, if you have any reason not to trust a user, they shouldn't be
working for you. Regardless of whether or not they can get into a database,
untrustworthy users have no place in a company.

 

[Bob]

That is very helpful. Thank You Banana

Well, you could use a query with an appropriate WHERE clause to restrict
rows to only which users are authorized to view/edit.

That will work for keeping honest users honest but if you need something
more than that, I would probably look for a RDBMS backend. With .mdb
format, you have the option of using ULS and running RWOP queries so it
can't be easily edited and requires more technical expertise but ULS &
RWOP queries still could be overcome, hence me suggesting a RDBMS
backend first.

 

[Alex]

Is it possible to restrict access to records for users. I want them to only
see their own records and not the records of others.

If so would you be able to give me some insight on how you would do that?

 

[Alex]

e me some insight on how you would do that?