1. With 30-60 users, you really need to consider a better database for the back end. (Mysql or Sql Server) Access will corrupt on you with all that traffic.
2. I would add a Field called 'Pending' that is boolean, default = 1 when a record is created, Pending = 1 and you can query for pending records. When you assign (POP) it to a user, put the User code in the record and set Pending = 0. --- In [email protected], Nikita Malhotra <[EMAIL PROTECTED]> wrote: > > > Hi Friends, > > Urget Help required! As I already told you that I am not professional in Access but I have got a project to work on MS Access. > > Now my project requires me to POP cases. The application is much like CallCenter service. > There are 15 fields in a table and records may vary from 2000 - 4000. There could be a 30-60 users working on the same application. The Records will pop to the user one by one. The record on which one User has worked/working will not pop to another User. > > I have decided that I will keep one Table wherein Date will be saved for User to work on. Once User has completed his job, it will be saved to another table. Once TableA is empty, that would mean that there is no more job available for user to work on. > > Please help me out to do this job as you are better professional and would have worked on the same many times in your career. > > I shall be thankful for your suport and looking forward for your reply. > > Regards,Nikita Malhotra================================United We Live, United We Stand....================================ > _________________________________________________________________ > Post ads for free - to sell, rent or even buy.www.yello.in > http://ss1.richmedia.in/recurl.asp?pid=186 > > [Non-text portions of this message have been removed] >
