Refresh of Listbox when underlying table being updated

[Guest]

My DB has two separate functions that access a table.
One is an administrative function that deletes/rebuilds the table.
The other function is a popup screen that displays the table in a listbox.

Today one user saw the pop-up screen with one valid row on it and then
several rows saying #Deleted

It was determined that someone used the administrative function and it
probably deleted/rebuilt the table as the other user was requerying the
pop-up screen listbox.
Is there any way to prevent the listbox on the popup window refreshing
during the delete/rebuild process? Or is it possible to detect the #Deleted
rows in the listbox before it is displayed, then do another requery?
Any help much appeciated.

 

[Perry]

This was a question posed in this newsgroup previously, wasn't it?
Pls stick to the thread if applicable.

I'm (as are others) trying to help you out, and since this is not the only
place
I'm feeding to, it's a but hard to keep track...
(it's for your own benefit)

Answer:
use privileges to circumvent other users to rebuild the table.

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE