Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JohannIcon
  • Order by date
  1. JohannIcon

    aspx page through SSL

    Hi All, I have an aspx page that is running through a Shared Certificate, and i'm getting the following error. "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as...
  2. JohannIcon

    Script triggered automatically

    Hi Nick I have to have a scheduled task, so that when the date and time, expires, the status is changed automatically, and so the user cannot log in and see that item. Unfortunately, I do not know how to write a VB Script cause I have never used VB.
  3. JohannIcon

    Script triggered automatically

    Dear All, I am inserting a date into the database, that is 48 hours from the current time, and I call it the expiryDate. What I want to do know is a sort of script that every minute checks this expiryDate in the database with the current date/time and if it is equal, or smaller, then, I change...
  4. JohannIcon

    insert date and time in MS Access Database

    Thanks Mate!
  5. JohannIcon

    insert date and time in MS Access Database

    Dear All, I need to insert a date and time exactly 48 hours more from the current time in an MS Access Database How can I do it please?
  6. JohannIcon

    MS Access Database locked!

    I already tried to stop the IIS but to no avail. No i am only using the database on the localhost, the others use it from the server.
  7. JohannIcon

    MS Access Database locked!

    I also ran a special script to be sure that the session is closed:- response.expires = 0 Session("username") = "" 'Access lasts for session Session.Abandon() response.redirect("login.asp") but it is still opened!
  8. JohannIcon

    MS Access Database locked!

    Hello Shaddow, I tried to include set f=nothing set fso=nothing but still the page got stuck! The problem seems to be in this line (on on the localhost!) Set f = fso.GetFile(path)
  9. JohannIcon

    MS Access Database locked!

    I tried to remove this code:- path=server.mappath("../../../databases/") & "/merlin.mdb" Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(path) lastmodified=f.DateLastModified lastmodified=dateAdd ("h",6,lastmodified) And now it...
  10. JohannIcon

    MS Access Database locked!

    So basically I think the only solution is to rename the database and see if it happens again.
  11. JohannIcon

    MS Access Database locked!

    Does this code affect the IIS and leaves the database open? path=server.mappath("../../../databases/") & "/merlin.mdb" Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(path) lastmodified=f.DateLastModified lastmodified=dateAdd...
  12. JohannIcon

    MS Access Database locked!

    Hello Shadow, You just mentioned the Date/Time Created/Modified, and I am thinkning that since I have implemented this function, that the database is being left open! But only on the localhost! To reply to your question:- mdb file :- modified 2/11/2004 12:36 ldb file := modified...
  13. JohannIcon

    MS Access Database locked!

    I already tried to stop IIS but the .ldb file is still visible, although I refreshed the folder. Can't get the hack out of it yet! Really strange! It only happened this morning, and I have been working on this code for about a week, that is why i am lost!
  14. JohannIcon

    MS Access Database locked!

    Hello Shaddow, I do not use a global.asa but I pass session variables, and this is a "copy and paste script", ie I always use the same code and it has never happened before. 2) No other Application uses this database. The funny thing is that on the server, everything works fine, only...
  15. JohannIcon

    MS Access Database locked!

    Dear All, I am trying to delete an MS Access Database, however it is telling me that The Source or Destination File may be in use. And I am sure that the database is not open on my localhost! I tried to reset my PC and IIS, however, it is still appearing as open (database.ldb). How can I make...
  16. JohannIcon

    Last Modified

    Ok I tried Shaddow's code and it worked perfectly, thanks Shaddow!
  17. JohannIcon

    Last Modified

    Thanks Shaddow, I will surely give it a try! Thanks again
  18. JohannIcon

    Last Modified

    Hello foxbox I am using an MS Access database. What I want to know is - the last change date/time the user made a change to the database/table. So how do you go about and setting up a trigger? Can you give me more info please Thanks for your help and time
  19. JohannIcon

    Last Modified

    Yeah that is what I though in the first place, ie when the user presses the submit button (ie changing data) a date is written in a field. However I thought that there was something simpler to get the date that the database was last modified or something of the sort.
  20. JohannIcon

    Last Modified

    Dear All, I am trying to implement a function where the user will know when he last did amendments on the database. One way that came up in my mind was to include a function after the user presses the submit button. Is there an easier way to get the date of the last modification of the...

Part and Inventory Search

Back
Top