I have been adding the file size for my downloads into a Access database but i have around 1000 videos and so writing the file size in each time and get a bit much. I was just wandering if anyone knew an easier way? or if there is a way i can read the file size from my web server? thanks for any help

you could use the FSO (File System Object)

function getFileSize(filename)
dim objFSO,movFile
Set objFSO= CreateObject("Scripting.FileSystemObject") 
Set movFile= objFSO.GetFile(server.mappath(filename))
getFileSize= movFile.size
set movFile = nothing
set objFSO = nothing
end function

filename should include the relative path to the file as well
so;

MovieName = "armageddon.avi"
MoviePath = "/movies/a/"
FileSize = getFileSize(MoviePath & MovieName)
strSQL = "UPDATE table SET sizefield = " & FileSize & " WHERE namefield = " & MovieName & " ;"

you could also set this into a loop to run through each file in any given folder

Worked a treat, thanks