Runtime Delete Query Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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..
 
Hi Vambo,

There have been some reports of Access applications failing after
installation of Office 2003 Service Pack 3. I don't know the details,
but searching the web or the newsgroups should find them.
 
Back
Top