Refresh Data via ODBC while Front End forms are open??????

[James W]

Hi All.

Client Server network with Access retrieving data from another Non-Access Db
through an ODBC connection updating overnight while users are
sleeping.......

The problem is that updating every 24 hours is not enough in a high stock
turnover environment.

Is there a way that I can lock out users say.... every hour for the 20 - 30
seconds it takes to update the data table via a macro at the "back end"?

Conceptually what I am saying is.... Can I temporarily sever the connection
between the open forms that the user sees and the table containing product
data which resides on the server whilst the data updates and then
"re-establish" the connection automatically?

THERE MUST BE A WAY!

Any suggestions?

T.I.A.

 

[Douglas J. Steele]

Afraid I don't understand what you're looking for. Are you importing the
data, or have you linked the tables? If it's linked, then your data will be
live: there should be no need to update the data.

 

[James W]

Sorry mate. I should have been more specific.

I am importing the data.

The Macro deletes the "Old" Data and imports a new table with the fresh
data.

 

[Douglas J. Steele]

One approach is to have a flag in the application (such as a field in a
table) that you check whenever you open a form. If the flag is set, don't
let them open the form. You can also use a timer on the form so that it
checks the flag's value on a regular basis, in case they've left the form
open.

 

[James W]

The problem is that the form the users see has to be open all the time. This
is the crux of the difficulty.
I need to temporarily "suspend" the use of the form for 20 - 30 seconds
while the update takes place WITHOUT closing the main form.