thenoisydrum
Registered User.
- Local time
- Today, 20:32
- Joined
- Jul 26, 2012
- Messages
- 52
Good morning all,
I am designing a fairly simple database for a client. Top level, they have asked for a couple of forms to be designed for inputting data into tables.
They have a set number of admin people that they would like to be able to have access to all tables within the database - the whole shebang.
They also have a number of users, that will be responsible for simply entering the data into the forms.
My client would like it to be that user A (for example) can only see the records that they have entered.
Does MS Access have the ability to set this type of thing up? I don't believe that it does. Please let me know your thoughts.
I think that the best way to manage this would be to have a central database with the tables for users A - H (for example).
These tables would be linked to 8 databases that live on the 8 user's individual 'drives'.
That way, each user would only be able to see the records that they entered.
Each of the 8 source tables could be added to a 'master' table every week, or what ever.
The central database would live on a 'drive' where the admin users could open it and view and edit the objects and do all the analysis.
Thanks in advance for your help
Drum
I am designing a fairly simple database for a client. Top level, they have asked for a couple of forms to be designed for inputting data into tables.
They have a set number of admin people that they would like to be able to have access to all tables within the database - the whole shebang.
They also have a number of users, that will be responsible for simply entering the data into the forms.
My client would like it to be that user A (for example) can only see the records that they have entered.
Does MS Access have the ability to set this type of thing up? I don't believe that it does. Please let me know your thoughts.
I think that the best way to manage this would be to have a central database with the tables for users A - H (for example).
These tables would be linked to 8 databases that live on the 8 user's individual 'drives'.
That way, each user would only be able to see the records that they entered.
Each of the 8 source tables could be added to a 'master' table every week, or what ever.
The central database would live on a 'drive' where the admin users could open it and view and edit the objects and do all the analysis.
Thanks in advance for your help
Drum