Multiple users cause table conflict

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 18 May 2007 20:23 GMT

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.

Reply to this Message

Perry - 19 May 2007 16:36 GMT

> Is there any way to prevent the listbox on the popup window refreshing
> during the delete/rebuild process?

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

> My DB has two separate functions that access a table.
> One is an administrative function that deletes/rebuilds the table.
[quoted text clipped - 9 lines]
> during the delete/rebuild process?
> Any help much appeciated.

Reply to this Message

mscertified - 21 May 2007 17:43 GMT

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.

> > Is there any way to prevent the listbox on the popup window refreshing
> > during the delete/rebuild process?
[quoted text clipped - 26 lines]
> > during the delete/rebuild process?
> > Any help much appeciated.

Reply to this Message

Perry - 22 May 2007 00:39 GMT

> The listbox refreshes as the user types characters in a text
> box or presses a command button.

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

> It's not refreshed via a Rowsource in the properties but dynamically via
> SQL
[quoted text clipped - 37 lines]
>> > during the delete/rebuild process?
>> > Any help much appeciated.

Reply to this Message