On Wed, 14 Apr 2010 10:56:01 -0700, GD wrote:

In other words, I'm wanting to update the background tables periodically
(perhaps even daily), in preparation for users' data entry, but without
having to ask them to exit the front end database every time.

Should be no problem at all. Access shares tables very nicely; the user will
only get a warning message, even if they're trying to edit the exact same
record you're updating as you're updating it. If they look for it ten
milliseconds after you update it they'll get the new value

--

John W. Vinson [MVP].