By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,036 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,036 IT Pros & Developers. It's quick & easy.

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

P: 2
*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.
May 25 '14 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,430
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.
May 25 '14 #2

P: 2
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.
May 25 '14 #3

Expert Mod 10K+
P: 12,430
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.
May 25 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.