allocating records per user

[ianhornby]

Anyone any ideas, please?

I have a table of name and address data as a back end and have put a front end of each of 12 "user" computers on a workgroup-based small network. Each user can look at on twelfth of records, the range being specified in a query on each front end PC, which, of course, means that each front end has to be slightly different.

I wonder if it's possible to assign some sort of owner system so that whenever "user1" logs on he/she gets the first twelfth of the records, user2 gets the next set and so on.

As a separate issue, can I somehow work out the start and end records needed for each user by automatically dividing the total number of records by 12 (since the master table can have a different number of records each time we get new data). At the moment I am calculating (using Excel) and inserting the ">1200 <2400" for each user.

Any ideas would be gratefully appreciated.

 

[Guus2005]

Noneed to change the FE slightly. You have to monitor who's logged in. That user gets a unique ID. For instance a guid (or his/her own userid). You assign this user 12 records. Each record has(must have) a field where the unique ID can be stored. This way no other user can use this record. Is it important that the first user gets the first 12 records?