access level question

[behrad]

How can i make the following access level in a MS ACCESS 2003 database?
level1----------->[Table A : Data Entry],[Table B : Only view]
level2----------->[Table B : Data Entry],[Table A : Only view]

 

[Colin@Toyota]

[Table A : Data Entry],[Table B : Only view]
Table B : Data Entry],[Table A : Only view]

Hmm... In Access you should not be using the tables themselves for data entry; this creates too many opportunities to mess up the raw data contained therein. Through the use of forms, you have the options to set whether the user has the ability to modify or add data, or only view it.

I think it might be beneficial for you to do some reading on some topics including database normalization, data entry forms, and Access in general. Try searching, and if you can't seem to find anything that makes your situation a little clearer, post back, and I will try to point you in the right direction.

 

[behrad]

Thanks Colin,
I know i can make limited access with forms , but professional users can open table directly and change data in it.
With a secure workgroup all of table / query will be included in the same access level , but i want to make different access level for tables in a same access data base.
for example :
level1----------->[Table A : Data Entry],[Table B : Only view]
level2----------->[Table B : Data Entry],[Table A : Only view]