[RESOLVED] Progress Database Problem

[LostAngel]

Hello, we use a manufacturing program called TMM that uses a Progress backend. Recently, we noticed that pretty large files are being created in a directory in TMM. When I open these, it seems to be data from places in the progress database. Any time a query is ran (though VB or WinSQL), it seems a file is created...I am only running SELECT statements, no insert/updates. With WinSQL, there is an option to "Auto Commit Transactions". When this is checked, the file is deleted after the data is stored. Does anyone know how to do this in VB? I have tried cnTMM.CommitTrans, but it doesn't work (I guess it only works when you are inserting data). Below is how I connect to the database:

Public Sub ConnectTMM()
Set cnTMM = New ADODB.Connection
    cnTMM.CursorLocation = adUseClient
    cnTMM.ConnectionString = "Provider=MSDASQL.1;" & _
    "Password=PASS;" & _
    "Persist Security Info=True;" & _
    "User ID=sysprogress;" & _
    "Password=PASS;" & _
    "Data Source=tmm_db10"
    cnTMM.Open
End Sub
 
Public Sub OpenTMM(strsql As String)
Set rsTMM = New ADODB.Recordset 'as we did with the connection    txtQuery.Text = strSQL
If rsTMM.State = adStateOpen Then rsTMM.Close 'If Open,  Close.
     rsTMM.Open strsql, cnTMM, adOpenKeyset, adLockOptimistic, adCmdText  'Opens Recordset.
End Sub