|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Database Locked!
Dear All,
I have inserted this piece of 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) so that I can determine when the user has modified the database. However the problem is that on the server, it works fine, however, on the local server (IIS) on my pc, everything seems to get stuck. Also it locks the databases (.ldb) and I cannot do any amendments on this database, if i don't restart the PC. Can you please help me out? Thanks for your help and time |
|
#2
|
|||
|
|||
|
Are you running any antivirus software?
If so disable it. And see if that is your problem. or Do you have the database open when you are connecting to your web application? If so make sure you close it. |
|
#3
|
|||
|
|||
|
I tried both solutions but still the same problem, the asp page got stuck!
The problem is this line for sure :- Set f = fso.GetFile(path) Cause when i comment it out, it works fine. |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Database Locked! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|