Recorded is being used and by whom it is used by and when they checked it out.

[hotflash]

Hi CroCrew et. All,

As always, when it comes to ASP, I think you are the best of all bests. We used to use a MS Excess as file sharing on the server. Each time when there is a user opens the file, and a second person comes in, he/she can't save to the file because of a first user already had it opened either to view or edit.

I have moved it to a website, I created a search feature like: A (search for file A), and B (search for file B). Let's say when file A is searched, it will display the file A name, and you can either View or Edit. The file for this is DisplayFile.asp.

What do I need to put in the DisplayFile.asp, or EditFile.asp to make it lock the file so others won't be able to view or update it? Thanks for your help.

[CroCrew]

Hello hotflash,

Did you figure this out? I am sorry that I did not respond to this post. I will look into it ASAP and hopefully get you an answer/solution by today. Or maybe someone else will get you an answer before I do hopefully.

Sorry,
CroCrew~

[hotflash]

Hi Master CroCrew,

Tried different options but still no luck. This is something way over my head and only the ASP guru like you can help. Thanks for your outstanding support.

[CroCrew]

Hello hotflash,

I just emailed you an example that you can look at.

Hope it helps~

[hotflash]

Hi Master CroCrew,

Your code is outstanding. Wow, this is something for a super advance person like you to create. As always, thanks for your outstanding support.

Questions for you:

1. Let's say, when the "Record is use by Cro Crew", once you are done, how can you return it to make the Record available for the next person that comes in? I can't seem to return it. Would it be easy to have a Release or Checkout button next to the "Record is use by Cro Crew" so you can release the record once you are done? It looks like you have set in the code for 30 minutes.

2. Let's say, if you are checkin, the status shows up like "Record is use by Cro Crew". Should the filename.xls (real example) will show up next to your name so you can edit/modify the file? I don't see where you can modify the file.

3. Is a new record get created each time a person uses the file so we can log them? So far it looks like the old information will be overwrited if i read it correctly.

4. Sometimes, if does not look like the Checkin is working properly because when i click on the "Checkout" button, there is an option for me to Checkin, when I select Checkin, I got a message like "Record updated and checked in" however, the status does not say that the "The Record is use by XXXX:.

[hotflash]

Hi CroCrew,

Any luck? Must be a tough one hah? Thanks for your help.

[CroCrew]

1. Let's say, when the "Record is use by Cro Crew", once you are done, how can you return it to make the Record available for the next person that comes in? I can't seem to return it. Would it be easy to have a Release or Checkout button next to the "Record is use by Cro Crew" so you can release the record once you are done? It looks like you have set in the code for 30 minutes.

Answer: After you hit the checkout button you should have a check in button to do just that “ Check in”.

2. Let's say, if you are checkin, the status shows up like "Record is use by Cro Crew". Should the filename.xls (real example) will show up next to your name so you can edit/modify the file? I don't see where you can modify the file.

Answer: You are not checking out a “file” with the program I sent you you are checking out a “record” within a database.

3. Is a new record get created each time a person uses the file so we can log them? So far it looks like the old information will be overwrited if i read it correctly.

Answer: You are reading it correctly.

4. Sometimes, if does not look like the Check in is working properly because when I click on the "Checkout" button, there is an option for me to Check in, when I select Check in, I got a message like "Record updated and checked in" however, the status does not say that the "The Record is use by XXXX:.

Answer: When you “check in” you are updating the database even if you don’t change any of the data. That is why you get the message. You can extend the code to check if any of the fields have been changed before check in and then show a more meaningful message like “Check in with out changes” or “Record updated and checked in”



Hope my answers to your questions helps. And please refrain from calling me “master” it is starting to get creepy.

Have fun coding~