MS Access recordset problem w/python

[Tres Seaver]

Bill Wilkinson wrote:
> 
> Question for those who have used Python with Access.
> 
> I am having a strange problem with Python and MS Access.  What happens
> is this:  I have a table in Access that is open.  If I delete some
> records from the table, and then run a python script that uses the
> table, the number of records remaining is wrong (I get the old value
> before I made deletions).  The only way to get the proper record count
> is to close the table in Access.
> 
> I have tried all the tricks, such as moving to the last record and then
> checking for the record count.  This problem does not exist if you are
> using VBA to check the recordcount.
> 
> Are there some refresh methods that I am missing somewhere?

It sounds like the deletion has not yet been committed, while VBA is maybe
running in "autocommit" mode.
-- 
=========================================================
Tres Seaver         tseaver at palladion.com    713-523-6582
Palladion Software  http://www.palladion.com