progressbar problem

[amit_m04]

hi
i am using vb 6 and ms access. i want to delete data from a table of an access database which contains about 5,000 records and i have a progressbar. But when the deletion process starts the progressbar should run as the records are deleted.
what i was thinking was to
1)first find out howmany records are present in the table
2)then divide that value with the progressbars max value,
3)delete the records with the remender that u get and increase the progressbar value by 1
but i am a bit confused with it so can u help me with some of ur ideas.
i am using adodc connection
can some one help me with the code.