How can multiple users pull a record and prevents other user to pull the same record?

[Lagarizta]

*single MS ACCESS FILE
*ACCESS FILE contains one form that serves as a query form. Form has a GENERATE button which will display on the right the row number record and will auto populate the form with the values from the table which was also in the same MS ACCESS FILE. After viewing the record, it will create a new table with additional information (initials of the user who accessed the row)
*the table in the same MS ACCESS FILE has 3 columns. First column shows name of planets. Second column contains numbers.
QUESTION: how can user "A" pull record number 1 and user "B" pull record that was not pulled by user "A"? 3rd pull should display the record that was not pulled by user "B" nor previously pulled by user "A"?
**what was pulled by user A and B will generate new table in MS ACCESS with their initials to know that they pulled the record.
NOTE: there will be around 50users who will access/work the same MS ACCESS FILE at the same time.

[Rabbit]

1) Don't create multiple tables for each user, that's a mess to upkeep.

2) When a user is editing a record, Access will lock the record for you.

[Lagarizta]

The new/2nd table will record what was previously pulled by other users. The file will not create one table for one user.

Is it possible for access or do i need to use another program? What I need to accomplish is to distribute the work to multiple users.

[Rabbit]

Whether it creates just one copy of the data or more, the point is you should avoid doing that because it goes against the rules of normalization.

My point is that if you just have one table, Access will take care of locking the records for you.