Thanks for your response.

This is a single database - not a split database.

KC,

I usually keep a table of program parameters (tbl_prg_Parameters) in my
back-end database.  You could create such a table and add a date field to
that table where you could store the date last updated.  Then in your splash
screens load event, you could check to see whether that date was equal to
todays date.  If so you could disable the control.  When you click the
control to update your tables, then also update this field to indicate todays
date.

That leaves you with the case where another user opens the form, but doesn't
do the update.  When you perform the update their command button will still
be enabled.  You can overcome this by: 1) putting some code in the click
event to test and see whether the value of that field has changed, and not do
the upload if it has.  In which case, you should also disable the control, or
2) You could use the splash screens timer event to check the value of that
field every so often.  Once it sees that the updates have been done, change
the timerinterval to zero so it doesn't do the checks any more that day.

HTH
Dale