I have a tool that I inherited with the job and have to support which involves an Excel Spreadsheet over an Access Database using ADO. The Excel Spreadheet is located on the users (about 30 total users) desktop and the Access Database it located on a Network Drive. The origional setup used drive mapping but I updated it to use the UNC path and made a great gain in the speed of the data flow. The tool is used for lobby control and gathering metrics about the clients they are seeing. So a client comes in and is entered into the database by a clerk at the front desk. Then a specialist will open their Spreadsheet and click the Find Next Client button to select the client.
For the most part I don't have any problems with the tool. It runs well and I have updated it giving the users more functionality. However I do have 1 issue that I just can't seem to fix. There is 1 column where the data for an entry, once selected by a specialist will be overwritten by another specialist and that specialist will try to call back a client that is already being assisted. I have tried to prevent this from happening within the spreadsheet but nothing Ive done works. Is there any way of locking the data in this column down within Access once it is entered so that another specialist cannot select a client already selected? Very fustrating for the users.
Thanks
For the most part I don't have any problems with the tool. It runs well and I have updated it giving the users more functionality. However I do have 1 issue that I just can't seem to fix. There is 1 column where the data for an entry, once selected by a specialist will be overwritten by another specialist and that specialist will try to call back a client that is already being assisted. I have tried to prevent this from happening within the spreadsheet but nothing Ive done works. Is there any way of locking the data in this column down within Access once it is entered so that another specialist cannot select a client already selected? Very fustrating for the users.
Thanks
