Multiple users cause table conflict

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
Any help much appeciated.
 
Is there any way to prevent the listbox on the popup window refreshing
during the delete/rebuild process?
Click to expand...

You can remove the rowsource from the listbox and re-instate the rowsource
after execution.

You still have to figure out when the other user deletes/rebuilds the table
and how this relates to
the abovementioned work-around.
--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
 
It's not refreshed via a Rowsource in the properties but dynamically via SQL
within the code. The listbox refreshes as the user types characters in a text
box or presses a command button.
The table can be deleted and rebuilt at any moment though its not a common
occurrence.
 
The listbox refreshes as the user types characters in a text
box or presses a command button.
Click to expand...

Then change the rowsource according to what other users have entered.

You still have to figure out when the change happens.
--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
 
Back
Top