Public Sub AddGameFile(sFile$, GameID As Long)
On Error Resume Next
Dim sSql$, Rs, bFile() As Byte
sSql = "select * from FileInfo"
Set Rs = CreateObject("ADODB.Recordset")
Rs.CursorLocation = 3 ' adUseClient
Rs.CursorType = 1 'adOpenKeyset
Rs.LockType = 3 'adLockOptimistic
Rs.Open sSql, Conn, , 2
Rs.AddNew
Rs("FilePathName") = sFile
Rs("FilePathNameA") = sFile
Rs("GameID") = GameID
Rs("FileDate") = Now()
Open sFile For Binary As #1
ReDim bFile(1 To LOF(1))
Get #1, 1, bFile
Close #1
Rs("FileContent").AppendChunk = bFile
Rs.Update
Rs.Close
End Sub