Access users

[Captain]

Hello!

Have some problems with one DB sturcture.
I have one DB (for exp. test.mdb) with one big table coll. 30x rows 500
I am need to create 3 users.
first user can see all table and modify all rows.
second user can see only half af this table and modify only his rows
third user can see 2 half of table and modify only his rows.
Main DB (test.mdb) need to be in local network and this 3 users will be can to connect from his PC.

It is possible to create without SQL Server?
I know only know how it can solved with SQL server. But how create this without server I dont know.
May be it is need to create 3 tables?



Thnks for help.

[Datagopherdan]

You can use the security wizard to secure the database and then from there you can select user groups and permissions for groups and users. If you do a google search on it, you're sure to find some sites that will explain the process, which will be a piece of cake for you if you're familiar with SQL Server.

Dan
Access Development

Hello!

Have some problems with one DB sturcture.
I have one DB (for exp. test.mdb) with one big table coll. 30x rows 500
I am need to create 3 users.
first user can see all table and modify all rows.
second user can see only half af this table and modify only his rows
third user can see 2 half of table and modify only his rows.
Main DB (test.mdb) need to be in local network and this 3 users will be can to connect from his PC.

It is possible to create without SQL Server?
I know only know how it can solved with SQL server. But how create this without server I dont know.
May be it is need to create 3 tables?

Thnks for help.

[Captain]

In security wizard I can only create permissions for groups and users on tables but not on collums. I need to create permissions on collums. One user can see only his collums and rows.

[Datagopherdan]

I'm assuming that you need to set it like that to do something like limit the views, so users can only see the records that they created or are assigned to them.

You could do this programatically by using the CurrentUser function. If the database is split and each user has their own front-end. You could have a field in the table that would set to the username of the person who is creating the record. You would then create a query(ies) with the criteria set to the current user for whatever form(s) you need to limit the data the user can view.

You can set this a number of ways such as having a hidden form with an unbound text box to get the currentuser when the database opens and then reference that text box in your queries. This will limit them to only seeing their records.

Dan
Access Development

In security wizard I can only create permissions for groups and users on tables but not on collums. I need to create permissions on collums. One user can see only his collums and rows.