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




*** Sent via Developersdex http://www.developersdex.com ***

I tried to delete the .ldb file, however, it told me that Access was
denied, quite funny since I am using it only myslef!

*** Sent via Developersdex http://www.developersdex.com ***

On Thu, 12 Feb 2004 01:59:19 -0800, Johann Montfort
[quoted text, click to view]

The lock file isn't from the FSO command, it's an Access issue.
There's no *easy* solution, but check an Access group for information
on Access lock files. You may be able to simply deleted the LDB if
you're sure nobody has Access open.