V
Vambo
Hi, I run an Access 2003 system where the reference data and user data are
kept in 2 separate DB's, the ref data is updated monthly and issued to the
users. The user db is updated with the new ref data by linking tables and
then running delete/update queries.
I have discovered this method has stopped working for some users lately,
the previous months data is left intact, the users don't get an error message
of any type, and I can't figure out why. (It also affects certain users when
importing data to a temporary table which should be cleared before each new
import).
It still works perfectly on my test machine (an XP Home machine with only a
Runtime version of 2003 installed).
The users are mostly on XP Pro but there are a couple of Windows 2000 users
(who don't have the problem).
I wondered if there had been an update recently that may be affecting this
operation.
Cheers
V..
kept in 2 separate DB's, the ref data is updated monthly and issued to the
users. The user db is updated with the new ref data by linking tables and
then running delete/update queries.
I have discovered this method has stopped working for some users lately,
the previous months data is left intact, the users don't get an error message
of any type, and I can't figure out why. (It also affects certain users when
importing data to a temporary table which should be cleared before each new
import).
It still works perfectly on my test machine (an XP Home machine with only a
Runtime version of 2003 installed).
The users are mostly on XP Pro but there are a couple of Windows 2000 users
(who don't have the problem).
I wondered if there had been an update recently that may be affecting this
operation.
Cheers
V..