This question is based around some previous question in regards of the following:
We have over 3,500 Cds we manage from the server and deliver the images to workstations where they are loaded as virtual drives and the contents is used.
Because the contents can be - application (where program may need to be installed on local workstation) and data available on the CD, web pages on CD etc
Currently using MS Access to manage selections made by user on workstations and tracking use via shared names for each CD on server so as not to exceed licencing requirements (couldn't think of any other way at the time) - this is required because we don't know when a user on workstation is actually finished with a CD until the share is released.
This appears to be working well - except there may be evidence that due to the number of shares on server this might be slowing down the network at various times depending on number of workstations in use at the same time.
Can anyone suggest another way of detecting when a CD has been finished with so as to take the workload dealing with shares off the server. I thought of just recording the info in the database but couldn't see how to ensure database was updated when CD was finished with due to the nature in the way many of them work.
On a good day the share info on server takes 2 minutes to update and I suspect at busy times it is a lot longer and may have caused some network issues at extremely busy times.
I have researched and found some CD management Apps but unfortunately you don't seem to have the flexibility we need in the types of data to be recorded for our searches etc.