The objects last quite long because it's a huge database (about 730000 records) and it takes a few minutes to load, that is why I wanted to track the progress so the user know that something is happening. As for now, I implemented "pulse" progress bar to notify the user of activity, however accurate progress bar would be nicer
Roger Upole wrote: > It's likely your recordset and connection objects are going out > of scope before they get a chance to fire any events. As soon as > the function exits, both of the COM objects will be released. > > Also, you might want to use the named constants from > win32com.client.constants in place of hardcoded values. > rs.CursorLocation=win32com.client.constants.adUseClient > makes the intent much clearer. > > hth > Roger > > _______________________________________________ > Python-win32 mailing list > Python-win32@python.org > http://mail.python.org/mailman/listinfo/python-win32 > > _______________________________________________ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
